I have a lookup query in a form for registering for exams by exam number and title, but the same exam can be given on different dates, which are in the database.. For example Exam 1 can be given on many dates, some of those dates are in the past, but are still in the database. I would like the lookup to only give future dates. Any ideas on how I could do that?
See attached.