Go To New Record on Form Open

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Hi,

I have a form for entering volunteer data. That form is accessed via a
command button on a 'Options' form with multiple buttons where a novice user
can enter new records, update certain fields, print a report, etc... What
I'd like to do is two-fold:

1 - I'd like the 'Enter New Volunteer' Button to take the user to a new
record. Do, if there are 250 records in the table when they select the
option, I want to automatically take them to a blank record 251 so they can
add the data.

2 - I'd like them to get the Options form when they start Access. Right now
they can select the Options Form from the forms tab but I'd like this to be
automatic; how would I do that so they start on my Options Form?

I have taught myself Access so I could help a volunteer coordinator for a
rather large event maintain and schedule about 1500 volunteers in 5 or 6
venues later this year. I just haven't been able to figure these two issues
out and have not found the answers in the online training.

Thanks in advance for all your assistance.

Steve
 
You can use either:

DoCmd.OpenForm "Formname",,,, acFormAdd

which will open the form in Add mode, or

DoCmd.OpenForm "Formname"
DoCmd.GoToRecord acNewRecord

to get all the records and then go to a new one.
 
Thank You - I modified the code to use the acFormAdd stmt and that worked.
When I tried using the second option (the Open and Goto), I couldn't get it
to work in Access2003.
 
Back
Top