Hi all
I want to add a filter to my query the value has to come from a combobox of a form.
It can be done like this: =[Forms]![frmFORM1]![cmbFILTER].[Value]
This works.
But now I want to add wildcards and then the querry does not work.
Filter: like '*[Forms]![frmFORM1]![frmFORM1].[Value]*'
I think access just does not allow this ?
Is there an other fix ?
Can I do it with VBA like how you change the recordset from a form -> (...recordset = SQL)
But how do I refer to a specific query in my database.