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

[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

 

[Baz]

Set the Form's DataEntry property to True.

 

[Linq Adams via AccessMonster.com]

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