Only show Employees that are active?

[pixiedust]

I have an employees table with a field called Status. It is a text field: Active or Inactive. Without changing it to a yes/no; is there a way to code so that if it says Inactive, that employee will not show up in any dropdown combo boxes??

Thanks!

Pixie

[missinglinq]

Create a query based on your table, and in the Criteria box for your Status field, enter "active" (with the double quotation marks) then create your combobox based on this query.

Welcome to bytes!

Linq ;0)>

[Trevor2007]

I agree with MisingLinq

[NeoPa]

Principally the same as Linq but I would use single-quotes within your SQL (See Quotes (') and Double-Quotes (") - Where and When to use them).
[CODE=SQL]...
WHERE [Status]='Inactive'
...[/CODE]