Drop down list to select time

[DMARSJANIK]

I am creating a scheduling database and would like to allow the data entry user to pick the appropriate time form a list box instead of typing it in. Can this be done. When I try to create a list box I get an errror that says you cannot do this with a date/time format.

Thanks for your help

 

[gemma-the-husky]

a date picker is easy, because a date is discrete.

a time is not discrete - so to have a time picker you need a combo box consisting of time strings. pick one, then convert it to a time.

"00:30", "01:00", "01:30" etc.