Deleting data in fields based on another fields value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a simple database that is being used as a board to indicate whether
an employee is at work or not. One of the fields is a combo box that
indicates either in or out. If an employee is "out" of the building, there
are fields to provide information as to "location", "comments" "return date"
and time of return. I would like to delete the data in these fields
automatically when an employee is returned to "in" status. Any suggestions.
 
Shawn

In the combo box's AfterUpdate event, use some code to set the values of the
other fields to Null. For example (untested aircode):

If Me!cboYourComboBox = "In" Then
Me!txtOtherControl1=Null

Jeff Boyce
<Access MVP>

Shawn said:
I created a simple database that is being used as a board to indicate whether
an employee is at work or not. One of the fields is a combo box that
indicates either in or out. If an employee is "out" of the building, there
are fields to provide information as to "location", "comments" "return date"
and time of return. I would like to delete the data in these fields
automatically when an employee is returned to "in" status. Any
Click to expand...
suggestions.
 
Back
Top