need to clear form data on entry

K

Kirt84

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.
 
K

Kirt84

Yes! Thank you that is great, but I can no longer search through records. Is
there a way of doing this?
 
R

Rick Brandt

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.
 
Top