Program Button that wipes 1 single feild on a form

[Guest]

I have a fairly complex form... with several subforms on it.
I would like to set a button on the main form that wipes 1 single field.

I currently have a field that accepts a requested instructor... this field
is a list box for various reasons. I have had a problem where some people
using the system have accidentally selected an instructor when one had not
actually been requested.
The only current remedy is to hit escape, or use the clear form button that
I have added... this unfortunatley clears ALL the entered info for the
current entry.

Is there any way to set up a button that would clear a single field on a
form? or de-select an item from a list box?

The only way I have been able to do it so far is to go into the table view
of the DB and find the record and delete the incorrect request.

Any help would be REALLY appreciated!!

Thanks !

 

[John Vinson]

Is there any way to set up a button that would clear a single field on a
form? or de-select an item from a list box?

Sure.

Private Sub cmdClearInstructor_Click()
Me!lstInstructor = Null
End Sub

Or, why not simply select the instructor row in the listbox, and press
backspace to null it out?

John W. Vinson[MVP]