Sorting Data in a Combo Box

[Mutant_Mike]

Ok I am sure this questions has been asked a million times, so I apologize and ask if you could just point me in the right direction. The keywords I am using for my searching dont seem to be bringing up anything useful.



Ok, On he other hand if this is a new topic here is my problem and questions.

I am creating a database to track and schedule task for a group of techs on a day to day basis. Techs has to be assigned to tasks at various time of the day.

So I have a form linked to a table that allows me to enter the following data

Task (Text Format)
Start Date (Date/Time Format)
End Date (Date/Time Format)
Start Time (Date/Time Format)
End Time (Date/Time Format)

Combo box to pick an available tech.

What is the best way to sort the combo box so that it only shows the tech that available for the task (Date and Time) I am creating. Of course the Date and time fields will be filled in first.

[June7]

The RowSource of the combobox would be a query that refers to the Start and End Dates boxes. Like: SELECT techID, techName FROM tablename WHERE datefield BETWEEN #" & [startbox] & "# AND #" & [endbox] & "#;"

What date field(s) are in table to use in the Where clause?

Then need to trigger a requery of the combobox. Could be a button click or the AfterUpdate events for the date boxes. Maybe just the End Date box.