[MS_AccessPros] Filter list box by combo

 

I have a list box called lstAppointments and I would like to filter it by using a combobox called cboTimePeriods. I am using the following values in the combobox.

1;"This week";2;"Next two weeks";3;"This month";4;"This quarter";5;"This calendar year";6;"Next 12 months";7;"All appointments"

This is recordsource for the lisbox:
SELECT [tblAppointments].[AppointmentID], [tblAppointments].[AppointmentDate], [tblAppointments].[AppointmentDesc] FROM tblAppointments;

What would I need to do to get the filter working?

Thanks,

Art Lorenzini
Sioux Falls, SD

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 11
• New Files 3

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___