Open a form automatically on a new record

[dianchecht]

Bit dumb this but bear with me please. ( Access 2003 )
I have a form that I use to Search a database ( Locked )
I copied it so I can search and Edit the database
Now I want to copy it so that I Open it and automatically create a new record
No searching or editing just create a new record.
I thought this would be a simple normal database procedure you could tie to the form
but I can't find it . Any ideas gratefully accepted
Cheers
Wallace

 

[pritcham]

Hi

If you go into the Properties for the form (not the controls on it - the actual form itself), go to the "Data" page of the properties, and change the "Data Entry" option to "Yes" then this will do what you want.

Cheers
Martin

 

[dianchecht]

On the data page of the properties I don't get any options , it just comes
up blank . Any idea why that is ?

Cheers
Wallace

 

[dianchecht]

Figured it out
I had to click the top left corner to get at the forms properties !!

Cheers for the help

Wallace