Search results

I managed to figure out a solution using VBA: I created a string variable to compile my "WHERE" statement from the SQL code so that I can use as criteria only the visible combos: Dim rs As DAO.Recordset Dim db As DAO.Database Dim sqltext As String Dim qdfNew As DAO.QueryDef...

Hello, Thanks for your quick reply. Unfortunately, i tried your solution and the query is returning only one entry... Based on my example, it should return 3 entries..

Hello, I am trying to create a query based on 5 inter-dependent combo-boxes. At the criteria of each field than i want to "filter" i put something like [Forms]![FormName]![cbo1]. My main problem is that these combo boxes are all set to "not visible" (except the first one) at the begging and...