Combo Box to return list based on 3 diferent data cells on the ta.

[PLEEAASSE Help..........]

I am creating a employee scheduling DataBase, Does anyone know how to make a
combo box return a list based on Availability IN TIMES, OUT TIMES, And
CERTIFIED STATIONS, which are all in the same table, The Combo Box is located
on a seperate FORM in the same database.

 

[Andi Mayer]

I am creating a employee scheduling DataBase, Does anyone know how to make a
combo box return a list based on Availability IN TIMES, OUT TIMES, And
CERTIFIED STATIONS, which are all in the same table, The Combo Box is located
on a seperate FORM in the same database.

Got to the Query Designer:
Choose the table you want
Take the Field you want
Sort it as you want
Filter it as you want

Go to the SQL view
Copy the SQL-String

Go to the form --- Commbobox
paste the sql-string into the rowsource