no need to press add record

[baz]

Hi there
I have apop up form in the database for the user to add
data. Is there any way I can have this form pop up ready
for inputiing data with out the user having to click on
the add new record button.

Regards Baz

 

[Al Camp]

baz,
DoCmd.OpenForm "YourFormName"
DoCmd.GoToRecord , , acNewRec

 

[John Vinson]

Hi there
I have apop up form in the database for the user to add
data. Is there any way I can have this form pop up ready
for inputiing data with out the user having to click on
the add new record button.

Either use Al's suggestion (which is actually the best way), or if you
want the users to ONLY be able to enter data, not to edit old records,
set the Data Entry property of the form to True.