R
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…
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…