Filter a form ??

[steve]

I have a form that I want people to enter data one piece of data into.

I made a button that opens the form.

When people open the form I want them to be taken to the end of the
database were they can add the new record in other words normally you
would open a form and press >* to go to the end of the table where you
can add your data. I would like to make it easy so they can just open
the form and it automatically takes them to the end where they can
simply add the data and the auto number will be created for the data
they have added.
I dont want to lock people out if they dont want want to go back <
but I would like to make it easy for them to just open the form and it
automatically take them to the end where they can simply add the data
I have looked at the properties for the field but cant see anything
that will do this .

Thanks.

 

[Allen Browne]

In the Load event procedure of the form:

If Not Me.NewRecord Then
RunCommand acCmdRecordsGotoNew
End If

 

[steve]

In the Load event procedure of the form:

If Not Me.NewRecord Then
RunCommand acCmdRecordsGotoNew
End If

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.









- Show quoted text -

Thank you very much.