Hi, I can not search in my mainform after I do a search in my subform. After I perform a search in the subform and I try to search the mainform, I get a no records message box that I created because it can't find any matches EVEN THOUGH there are matches.
To solve this I have a reset button that closes and opens the form. That easy. But I kind of dont want to close and open the form. I just want to reset the search to SHOW ALL RECORDS.
I found one way to do this my re-establishing my RecordSource and that works...that shows all of the records again. But I still can not perform a successful search through the main form.
Any suggestions? I appreciate your help in advance.
To solve this I have a reset button that closes and opens the form. That easy. But I kind of dont want to close and open the form. I just want to reset the search to SHOW ALL RECORDS.
I found one way to do this my re-establishing my RecordSource and that works...that shows all of the records again. But I still can not perform a successful search through the main form.
Any suggestions? I appreciate your help in advance.