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.
 
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

default data based on data in another field. 3
Report on things not done 3
Populate data in cboBox from another cboBox 2
Split data in field on character return 0
Dlookup based on a Text field? 2
How do i input a date based on value in an another access field 2
Delete doesn't delete 3
Add multiple fields in a form 6

Back
Top