hi everybody, i hope this is a simple question for many of you. i have a subform within a main form. in the main form i builded a set of search/combo boxes and a command that has the following code:
Code:
cmdFilter_Click()
DoCmd.OpenQuery "query1", acNormal
End Sub
i referenced the query to the search/combo boxes and it does work, the command filters the query. but obviouslt when i press the button it opens a new window and display the query in table view. what i want is to see the filtered query in my subform instead of having it displayed in another window.
any help would be much appreciated!