exclude a record in a combo box in a query

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

Guest

I have a combo box I use for the following catagories

Patrol
Cruise Ship Terminal
Communications
Special Detail
Gate Detail
Sick Time
Comp Time
Vacation Time

The last three I want to specify the query not to show if it is "Sick Time"
"Comp Time" or "Vacation Time" is this possible....

Thanks in advance
jen
 
Jennifer said:
I have a combo box I use for the following catagories

Patrol
Cruise Ship Terminal
Communications
Special Detail
Gate Detail
Sick Time
Comp Time
Vacation Time

The last three I want to specify the query not to show if it is "Sick Time"
"Comp Time" or "Vacation Time" is this possible....

Thanks in advance
jen
Click to expand...

You didn't post your SQL of the combo box row source, but if you add a
WHERE clause, you can limit what is displayed in the combo box.

Here is an example of what it should look like:


SELECT Table1.DetailType FROM Table1 WHERE Table1.DetailType Not In
("Sick Time","Comp Time","Vacation Time");


Change DetailType to the name of your field and table1 to the name of
your table.
 
Back
Top