Hi,
I have a form that has a subform with a filter. VBA is this:
Me.Filter = "([house_number] > " & [Forms]![bulk_add_complaints2]![start_number] & ")"
Me.FilterOn = True
Me.Requery
The input name is start_number and the database field is house_number.
When I press the button for the filter I get:
Run-time error '5':
Invalid procedure call or argument
What am I doing wrong? I made sure the field returned in the query and subform is a number field so I can compare integers.
Thanks!
I have a form that has a subform with a filter. VBA is this:
Me.Filter = "([house_number] > " & [Forms]![bulk_add_complaints2]![start_number] & ")"
Me.FilterOn = True
Me.Requery
The input name is start_number and the database field is house_number.
When I press the button for the filter I get:
Run-time error '5':
Invalid procedure call or argument
What am I doing wrong? I made sure the field returned in the query and subform is a number field so I can compare integers.
Thanks!