How to clear a value in an option group in a form after saving?

  • Thread starter Christine in Houston
  • Start date
C

Christine in Houston

How do I clear a value from an option group in a form after the record has
been saved? If a value has been entered in error - i.e., there should not be
any value in that field - how do I return it to null from within the form.

I don't want the data-entry person to go to the data table to null out the
value. ESC only works in the form BEFORE the record is saved.

Thanks
 
J

John W. Vinson

On Wed, 21 Mar 2007 12:02:12 -0700, Christine in Houston <Christine in
How do I clear a value from an option group in a form after the record has
been saved?

By running an Update query.

The value is no longer on the form. It's in the table, and you need to change
it there.

John W. Vinson [MVP]
 

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

Top