Clear a form on entry

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

Guest

How does one clear all of the fields when entering a form? I have two forms
(one query and one data entry) and the user does not want to see the previous
results.

I attempted to use the forms on open and on load events to set the field to
null (field.value = NULL) but it did not like that. Is there anything else I
can do?

Thanks for all of your help!
 
For the form in question simply set the 'Data Entry' property to Yes. This
way when your user opens the form it will be on a new blank record.

You can also blank each control by code such as
Me.ControlName=""

Daniel P
 
Three ways to open the form for data entry, empty form

1. Set the form DataEntry Property to Yes
====================================
2. On the On open form command line, specify that it for data entry
docmd.OpenForm "FormName",,,,acFormAdd
====================================
3. On the OnLoad event of the form, insert the code to move to a new record
DoCmd.GoToRecord , , acNewRec
 
Thank you Ofer, that worked perfect.

Ofer Cohen said:
Three ways to open the form for data entry, empty form

1. Set the form DataEntry Property to Yes
====================================
2. On the On open form command line, specify that it for data entry
docmd.OpenForm "FormName",,,,acFormAdd
====================================
3. On the OnLoad event of the form, insert the code to move to a new record
DoCmd.GoToRecord , , acNewRec
Click to expand...
 
Thank you Daniel, it worked perfectly.

Daniel said:
For the form in question simply set the 'Data Entry' property to Yes. This
way when your user opens the form it will be on a new blank record.

You can also blank each control by code such as
Me.ControlName=""

Daniel P
Click to expand...
 
Back
Top