How to open a blank form for adding a new record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a form for adding/viewing employee records. I can open the form,
view records and using the navigation button, add a new record just fine.
However, I'd like to open the form using a command button so that all fields
are blank and a new record can immediately been added without having to use
the navigation button. Can anyone help me figure out how to do this?

TIA,
Rich
 
Hello,

I have a form for adding/viewing employee records. I can open the form,
view records and using the navigation button, add a new record just fine.
However, I'd like to open the form using a command button so that all fields
are blank and a new record can immediately been added without having to use
the navigation button. Can anyone help me figure out how to do this?

TIA,
Rich
Click to expand...

Code the command button's Click event:
DoCmd.OpenForm "FormName", , , , acFormAdd

Change "FormName" to whatever the actual name of the form to be opened
is.
 
Perfect!!!

Thanks Fred!!!





fredg said:
Code the command button's Click event:
DoCmd.OpenForm "FormName", , , , acFormAdd

Change "FormName" to whatever the actual name of the form to be opened
is.
Click to expand...
 
Back
Top