Filtering a Listbox with multiple values (1 Viewer)

[UKFlamingo]

Hello,

I was wondering if anyone could help me with an issue I am having.

I have a listbox which is populated with data from a table. I have 4 text boxes that when populated with data I want them to filter what is shown in the listbox.

I can do this with one textbox using query builder and the following criteria,

Like "*" & [Forms]![frmPlanningForecast]![FETextbox].[Text] & "*"

i need to do this again but with Dates for two other textboxes named Date From and Date To.

Date from being a date greater than or equal to what has been entered and Date To being less than or equal to.

What do i need to change with my criteria to make this happen.

Just to add I have code in the background that requery's the listbox when data changes in the textbox.

Please let me know If you need more details.

Thanks
Ethan

 

[Minty]

In your the criteria section of your query under your Date field put

Between [Forms]![frmPlanningForecast]![Date From] And [Forms]![frmPlanningForecast]![Date To]

I would advise removing spaces and other special characters from all your control and field names.