Hi
I have a search form. On that form I have a button which I press and get result form.
Syntax is like this:
DoCmd.OpenForm "ResultForm", , , strFilter, acFormReadOnly
When I do this search once that's fine. But when I change criteria and press the button again it tells me that my table is already in use.
Is there a way to put a button on a result form, and when I press it to close search form and result form and go back to the first form which I started from?
Thank you in advance
I have a search form. On that form I have a button which I press and get result form.
Syntax is like this:
DoCmd.OpenForm "ResultForm", , , strFilter, acFormReadOnly
When I do this search once that's fine. But when I change criteria and press the button again it tells me that my table is already in use.
Is there a way to put a button on a result form, and when I press it to close search form and result form and go back to the first form which I started from?
Thank you in advance
