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 "

Private Sub Search_actor_Click() Dim FilterStr As String Dim lngLen As Long If IsNull(Ages) = False Then DoCmd.OpenForm "Actor Search" FilterStr = FilterStr & [Forms]![Actor Search]!TxtAgeRange = [Forms]![Search Actor]!cboAge So I ran the above code and it's just opening up the form starting...

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...