UKFlamingo
New member
- Local time
- Today, 14:12
- Joined
- May 19, 2017
- Messages
- 6
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
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