add_record

[maxmangion]

i have a button in a form and when i click on it, it will open another form. Actually is it possible that when i click the button and opens the form instead of displaying the first record, i would like the form to display an empty record so that i can enter a new record. is this possible pls ?

Thanks

 

[louchey]

Add this code underneath the code to open form
DoCmd.GoToRecord , , acLast

Regards

Louchey

 

[Rakier]

Or, you can modify the open statement to:

DoCmd.OpenForm YourFormName, , , , acFormAdd

By adding the acFormAdd part, you will open the form in data entry mode and be able to add records.