Form ready for use without pressing add record

  • Thread starter Thread starter baz
  • Start date Start date
B

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
 
open the properties of the form, and under the property line that says


On Open, click the down arrow and select [Event Procedure]

Then click on the tab with the 3 little dots on the right ,
you will now be in the editor where you can put in the vba code.

the code you want to add here is the following:

DoCmd.GoToRecord , , acNewRec


close the editor and save the form..
and then open the form..., it will be in the add record state.

kevin
 
Back
Top