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

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

Guest

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.
 
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.
Click to expand...

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
 
Back
Top