Access MS Access Limiting Combo Box Options

F

francisd

Joined
Jan 19, 2012
Messages
1
Reaction score
0
Hi,

I've already used a lot of useful tips coming from this site but i have a problem that i can't seem to fix.

I'm creating a program that will be used to assign schedule on certain tasks. I also have a table (availablesched) where i have 3 columns (name, date and time). I created a form with 3 combo boxes. What i would like to do is for the combo boxes to not show the schedules that are already selected.

For example, If i select Name = Dan, Date = Feb 1, Time = 3:00 - 4:00, this combination should not show if i select a schedule for a different task,
 

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

Access Combobox in Access Visible based on Checkbox 0
Access Access 2007 - Using Cascading Combo Boxes to Filter a Query 0
Access I need help with a data entry form in Microsoft Access 97 2
Access MICROSOFT ACCESS -- Combo box help 0
Multiple dependent combo boxes 1
Access Access 2007 - append query only appending 0 rows??? 2
Access MS Access Combo Box Help 0
Combo Box that fills Text Box in form 4

Top