I have an entry for that when started displays the first record in the table. I have to hit the "new record *" key to get a blank screen with my autonumber displayed. How do I get the form to go immediately to the new entry, autonumber state? This will save a step for my user.

Thanks for the help.

Tom

In the form properties make the form data entry.

I did mark the form as data entry which gives me a blank screen to start with but it prevents me from seeing which record number I am adding ie 177 of 177. Instead it shows record 1 of 1 even thought the table has 176 records in it. Also, the Find button no longer works, it appears the other 176 records are not in it's reach. I would like it to be a blank entry screen waiting to add a record to the end of the table but still showing that this will be record 177. I see another screen in a different system doing this but I can't see any changes in the properties to reflect the different method. Help is greatly appreciated

[This message has been edited by tcaprice (edited 05-11-2001).]

Hi Tom, Got your email.

Try this on the on open event of the form:

'Function Macro1()
On Error GoTo Macro1_Err

DoCmd.RunCommand acCmdRecordsGoToNew


Macro1_Exit:
Exit Function

Macro1_Err:
MsgBox Error$
Resume Macro1_Exit

End Function

HTH,
ASH~