Filtering using Option Groups

D

Dave H

I have a form with 2 different option groups. One allows the user to select
the month of the year (i.e. March) and another the day of the week (i.e.
Tuesday). I then want to filter the dates within a combo box to show only
the dates for
that weekday within the selected month (i.e. all Tuesdays within March).

I have tried the following as criteria within the query:
[Me]![Forms]![Formname]![Month] for the Month column and
[Me]![Forms]![Formname]![Day] for the Day column
but I cannot get the combo box to populate.

If I hand type the values then the combo box populates. What am I
forgetting?

thanks,
Dave
 
Top