clearing field contents when starting a new record

  • Thread starter Thread starter Patti
  • Start date Start date
P

Patti

I have a form that had to replace a combo box in based on
a lookup field. I got it to work but now when I go to a
new record the contents of the last record is shown in
the form box. It isn't retaining the contents to insert
it into the next record but just displaying the
information. How can I clear the field?

Thanks in advance for your help.

Patti
 
If all you want to do is clear the combo box try
Me.ComboBox.Value=Null

Jim
 
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

Clear contents of an unbound text box on a bound form. 2
Clearing Combo Box When Advancing to a New Record 1
First Subform record gets modified when closing form 3
The newly created record is now shown in the form 3
Access Form - Lock Fields from Editing 0
How to clear the previous data 1
Clear the contents of a field when form is opened (Access 2003) 4
Need help with form objects 0

Back
Top