sort combo box from date field

W

WarriorMCB

Joined
Jul 12, 2007
Messages
45
Reaction score
0
Hi, I almost have my Calendar form complete! I need the combobox ([SchedDateTime]) to filter itself after a date is chosen. For example, the date entered is a Monday but in short date format, eg. 07/30/07. The combobox then displays all the Mondays times in the drop-down list. If Wednesday is the day chosen, only the Wedneesday Times are in the combobox, etc, etc...

I also would like to stop a duplicate time from being entered if it already appears for that day. Is there a way to do this, if so How?? (eg, the time slot 9-12 has already been used on another record, on a Monday, this time is no longer available for that day, so I need what ever the coding is to accomplish this task) Any and all help will be welcomed.

Thankyou
MCB
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date field to query combo box help 0
Please Help! I need date field to query combo box list 0
Query/Filter Combo Box 0
Query/Filter 0
Pop-Up Form According To Date 0
Too Tough for the pros...? to answer 0
Combo Box query from date help! 0
does anyone know how! 0

Top