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?
Click to expand...

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