Switching Back to Query Form

[Rick R.]

This is something that used to work in Access 2003, but when I upgraded to
2007 it stopped working. I am using a form to enter some query parameters,
open another form with the results, add some data, close that form and go
back to the search form for the next query. But it’s not working. Here are
some details:
I have a form (A) to enter query parameters, when the data is entered, hit a
command button that runs a macro to open a second form (B) that shows my
query results. This works fine. I then enter some data to the record shown in
form B. When I’m done I have a command button to “Find Another Recordâ€, but
it’s not working properly. It triggers a Macro that is supposed to close form
B and return to Form A (the search form) however it is closing BOTH forms.
Any ideas? I can get more detailed if needed, but I think I’m missing
something obvious – hoping one of you will say “just do this…â€
Thanks in advance! – Rick…

 

[KARL DEWEY]

It triggers a Macro that is supposed to close form B and return to Form A
(the search form) however it is closing BOTH forms.
I recommend opening form B in design view, looking a the property of the
command button to “Find Another Record†to see the macro name. Then open
that macro in design view and see what actions are called. Apparently is is
closing all form or some such or there are two action, one for each form
closure.

 

[Rick R.]

Thanks Karl. It's a simple one line macro - Close, Form, "Form B", No.
It closes form B and A - but not my "Main Menu" form, which is open the
whole time underneath.
It should close Form B and return to Form A with all the data still typed
in, I change one field (Vendor) and search again.
I can't figure out why it's closing both forms.

 

[Steve Schapel]

Rick,

Are you certain that this is when Form A is closing? Is it possible that
Form A is already closed, prior to the macro closing Form B?

Also, are you certain that Form A is actually closed, as against hidden,
or minimized, or open but behind the Main form?

What are the details of the actions on Form A which opens Form B?