I build the query "SearchQ" with criteria
Expand|Select|Wrap|Line Numbers
- (Like "*" & [Forms]![SearchF]![Equipment #] & "*")
Expand|Select|Wrap|Line Numbers
- (Like "*" & [Forms]![SearchF]![Location] & "*")
The search button is in the main form. I have the sub form "results". The command works great using vba
Expand|Select|Wrap|Line Numbers
- Private Sub Searchbar_Click()
- Me!Results.Form.RecordSource = "SearchQ"
- End Sub
Can anyone help?