Entering new record on form

  • Thread starter Thread starter Diane
  • Start date Start date
Hi Diane

On the On Open event of the form insert the following:

DoCmd.GoToRecord , , acNewRec

Assuming you're using Access 2000

HTH

Debra
 
How do I make the form go to a new record as I open it so
it is ready to fill in.
Click to expand...

Two possibilities:

- If you JUST want to enter data, and don't want to even see old
records, set the DataEntry property of the Form to True.

- If you want to default to entering new records, but still want the
ability to scroll back and see old ones, put the following VBA code in
the Form's Open event (by viewing the form's properties, finding the
Open event on the Events tab, clicking the ... icon and choosing Code
Builder):

Private Sub Form_Open(Cancel as Integer)
DoCmd.GoToRecord acNewRecord
End Sub
 

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

Similar Threads

Copy record info into new form 0
DMax on existing record to increment serialized # fails 1
Need new record on focus 2
To ready for new record next time form is opened 4
Linking Forms for new record 2
How to disabe the Tab Command to go next Form 1
Pass value from one form to NEW record in another form; then again 1
Separate Form 0

Back
Top