Anthony Law said:
When a user opens a form, I want the form to be blank.
How do I do this?
Do you mean that you want to open the form so that the user can add new
records, but not view any existing records? You can set the form's
DataEntry property, which will cause it always to display a new blank
record to the user for filling out. Or, if you only want to do this
sometimes, and while remaining able to view or edit existing records
other times, you can open the form in data entry mode using the line of
VBA code
DoCmd.OpenForm "NameOfYourForm", DataMode:=acFormAdd
