need to clear form data on entry

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

Guest

I have various forms and when opened I need the text boxes to be cleared (not
start new record). A command button is linked to open the form.
 
Kirt84 said:
I have various forms and when opened I need the text boxes to be
cleared (not start new record). A command button is linked to open
the form.
Click to expand...

Set the DataEntry property of the form to Yes. That will cause it to open
filtered to the new record position, but a new record is not started/created
unless the user actually enters something.
 
Yes! Thank you that is great, but I can no longer search through records. Is
there a way of doing this?
 
Kirt84 said:
Yes! Thank you that is great, but I can no longer search through
records. Is there a way of doing this?
Click to expand...

If you will often need to see other records then set DataEntry back to No
and instead run this code in the Open event of the form...

DoCmd.RunCommand acCmdRecordsGoToNew

If you will only occasionally need to do this then leave the DataEntry to
Yes and just use "Remove All Filters" in the main menu. That will take you
out of DataEntry mode so you can view other records.

The reason for the distinction is that opening in DataEntry mode is more
effiecient than doing a "GoToNew" if the table is large (especially if
running over a network). If most of the time you don't need to see existing
records then Data Entry Mode would be the preferred way to go.
 
Back
Top