Requery A Form From Another Form (Not A Subform)

L

Lythandra

I am not using subforms as there is simply no room on the screen so I am
opening up a second form from the first form. The user then enters the
relevant data and closes the second form. I would like first (original) form
to requery itself when the second form closes. I also have a bit of code that
I would like to run on the first form at that time.

I thought putting:
[Form]![First Form Name].Requery
in the second forms close event would do it.

I also tried putting a requery in what I thought were appropriate events of
the First form but it just stuck it into an endless Requery loop.

Any tips in the right direction would be appreciated.
 
D

Dirk Goldgar

Lythandra said:
I am not using subforms as there is simply no room on the screen so I am
opening up a second form from the first form. The user then enters the
relevant data and closes the second form. I would like first (original)
form
to requery itself when the second form closes. I also have a bit of code
that
I would like to run on the first form at that time.

I thought putting:
[Form]![First Form Name].Requery
in the second forms close event would do it.

Almost. It should be:

Forms![First Form Name].Requery

Did you try that? Based on the information you've provided, it should work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top