Open form in blank record

[Ed3m]

Hi
How can I make a button which allows the user to open another form containing many records and automatically move to the end of the datasheet to add a new record without clicking the next record button
Thanks.

 

[jcaptchaos2]

I'm not sure if this is going to help or not but you can change the "Data Entry" property of the form to "Yes" which will make the form default to a new record every time you open the form. However, the limitation is that you can't use the form to edit or delete existing records - you can only use the form to add new records.

 

[tails]

that last post helped me greatly, i wanna thank you for that post, even though it wasn't meant for me, it still has made my day. Thanks a tonn man, your a real help. I can now get over creating my program and go and do something else...
i bow down before thee ray:
your a real hero.... lol
thanks again

 

[Ed3m]

Where can i find the data entry property, I've searched though the forms properties, im also using access 2000.
thanks

 

[Norie]

The Data Entry property is on the Data tab of the Form property sheet.

 

[Ed3m]

Thanks for the help
One more thing....
The following code searches for a customer using their name, I would like to add a message box if the name does not exist or cannot be found.

Private Sub Command2_Click()
On Error GoTo Err_Command2_Click

Dim stDocName As String

stDocName = "Find customer"
DoCmd.OpenForm stDocName, acNormal, acEdit

Exit_Command2_Click:
Exit Sub

Err_Command2_Click:
MsgBox Err.Description
Resume Exit_Command2_Click

Thanks