Hiding cbo items if date = today and time > 12:00 PM (?)

[k3ll1n]

Was hoping someone would be able to point me in the right direction regarding this.


I'm creating a scheduler and would like to know how to remove the cbo items depending on the time of day.

On the form I have;

txt_appointment_date
(text box, date picker)

cbo_appointment_time
(drop down combo box that pulls all available appointment times from query: qry_available_appointments)

I would like to hide all cbo items if the date from the text box txt_appointment_date is TODAY and > 12:00 PM. Meaning they would have to pick tomorrows date for the items to return in the combo box. Employees have until 12 PM to book for the 2 PM - 4 PM openings.

Hope this makes sense.
Any help is appreciated.

Thanks!

[pbaldy]

In general terms, you'd set the row source property of the combo. Hard to be specific not knowing your table structure.