Access MS Access Limiting Combo Box Options

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,
 
Back
Top