how to load a new blank record

[Mo]

Hello,

Background,
I have created a small D/Base. Within the dbase, I have created a form with
text box.
The idea for the text box is for users to add a description of some sort,
then click on a ADD Button & new record is created.

Problem,
i would like to open up the dbase & go to a blank record rather go to the
first record.

Example,
I have 25 records in the dbase, when I open it I ought to go to record 26
which is a new blank record. Instead the dbase opens up in record number 1.

Any idea on how I can resolve this?

Thank you,

Mo

 

[pietlinden]

open the form in add mode.

 

[John Vinson]

i would like to open up the dbase & go to a blank record rather go to the
first record.

Example,
I have 25 records in the dbase, when I open it I ought to go to record 26
which is a new blank record. Instead the dbase opens up in record number 1.

Any idea on how I can resolve this?

Open the Form in design view; view its Properties. On the Events tab
find the form's Open event. Click the ... icon by it and choose Code
Builder. Access will give you the Sub and End Sub lines; edit it to

Private Sub Form_Open(Cancel as Integer)
DoCmd.GoToRecord acForm, Me.Name, acNewRecord
End Sub


John W. Vinson[MVP]