exclude a record in a combo box in a query

[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

 

[SteveS]

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

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.