Can the form defualt on the new record for data entry rather then on the first record

M

Mike Saifie

I created form for Data Entry, When I open it can it go to New record entry
automaticall, rahter then showing the first record.

Mike
 
G

Guest

Mike:

In the form's Open event procedure put the following line of code:

DoCmd.GoToRecord acForm, Me.Name, acNewRec

Ken Sheridan
Stafford, England
 
F

fredg

I created form for Data Entry, When I open it can it go to New record entry
automaticall, rahter then showing the first record.

Mike

Code the Load event of the form:

DoCmd.RunCommand acCmdRecordsGoToNew
 
B

Brian Bastl

Mike,

One last variation, combining the other two suggestions:

' Form Load event
DoCmd.GoToRecord , , acNewRec

Brian
 
J

John Vinson

I created form for Data Entry, When I open it can it go to New record entry
automaticall, rahter then showing the first record.

Mike

Set the Form's Data Entry property to True. Or... follow Fred or
Brian's suggestion to go to the new record in code; this is a bit more
work but has the advantage that you can use the form to see existing
records (Data Entry conceals them).

John W. Vinson[MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top