Setting input boxes to null

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

When I display my form some boxes display with the data
entered last time. How do I ensure that they are blank?
 
if your form is bound to a table, query or SQL statement, then normally it
will show the first record when you open it. if you want to always open to a
blank "new" record, either set the form's DataEntry property to Yes, or add
an event procedure to the form's OnOpen event, as

Private Sub Form_Open(Cancel As Integer)

DoCmd.RunCommand acCmdRecordsGoToNew

End Sub

hth
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hello happy new year to all, Text box input for year of purchase 0
Unbound text box calculation 6
Restrict entering Null or Empty in Textbox - Access 2007 0
How to make a text box null 2
Combo Box Problem 5
Get $0.00 to display on a Currency text box on a form 2
Replace "assign the null value" message 1
Clear Unbound Text box used as input parameter to query 13

Back
Top