In MS Access I want form to be open for fresh record entry

  • Thread starter Thread starter George
  • Start date Start date
G

George

Hi,

In MS Access when I am opening any form for new Record entry so I want the
fform to be opened for fresh entry only.
For Eg: Suppose there are 8 records in a the Table and when I am opening the
form for 9th Entry the Blank 9th record for entry should get open, it should
not open on 1st record.

Regards,


George
 
If you ***only*** want the form to be used to add records, Baz's advice is
right on the mark! If you want the form to ***open*** on a new record, but
also want to be able to use it to see the existing records, use this code

Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec
End Sub

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
 
Back
Top