Access

[gheyman]

Can you use VBA to Filter a filed in a Query

I have a Query (qry_OnTimeDelivery_MetricData)

I want to Filter Field: "MONTH0_Active" to the value "1"

I want to do this from a form using a Button. Can it be done using code?

 

[Joe4]

Yes, you can build the SQL query code via VBA, and apply to an existing query to update it.\
I have done that a number of times.

Here are some examples:
https://www.mrexcel.com/forum/micro...mbo-box-query.html?highlight=build+query+form
https://www.mrexcel.com/forum/microsoft-access/183758-dropdown-lists.html?highlight=build+query+form
https://www.mrexcel.com/forum/microsoft-access/325798-please-help.html?highlight=selection+form