Consulting

Results 1 to 4 of 4

Thread: Solved: new entry when opened

  1. #1

    Solved: new entry when opened

    In access 2003 is there a way to have the form set to a new entry. I have to hit the > key to go to a new entry page.

  2. #2
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    If you use a Command Button to open the form have a look at the Docmd statement.
    On the end of it type a , (comma) and it will give you a list of options, if "acFormAdd" is not there type another comma until it is in the list and then select it.
    There are normally 4 commas after the Form's name to get this form control, so you could try typing that in, but not if you have "criteria" set.

  3. #3
    VBAX Master CreganTur's Avatar
    Joined
    Jan 2008
    Location
    Greensboro, NC
    Posts
    1,676
    Location
    If you want to go to a new entry so that your users can enter data, then there's a property you can set.

    Go to your form in design view and look at your properties sheet. Go to the Data tab, look for Data Entry, and change it to "Yes". This will make your form so that only new records can be added.
    -Randy Shea
    I'm a programmer, but I'm also pro-grammar!
    If your issue is resolved, please use Thread Tools to mark your thread as Solved!

    PODA (Professional Office Developers Association) | Certifiable | MOS: Access 2003


  4. #4
    I worked, thanks for the input.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •