Search results

The following code is giving me error 3464. Please let me know what I'm doing wrong. Thanks If IsNull(Combo34) = False Then Str = Str & "(([Age] BETWEEN """ & Me!Combo34.Column(1) & """ And """ & Me!Combo34.Column(2) & """) OR([Age] > 65)) AND "

Form1 has an unbound combo box (cboAge) that shows different range of ages like 10-20 21-30 and so on. Form2 has a bound textbox (TxtAgeRange) which retrieves the calculated range of ages from a query (Age query). I cannot have an age column in the table because age is dynamic. Therefore, I'm...