Update / Refresh a Form Upon Entering Data in a Popup Box / Form

[aikiai]

I apologize if this has probably been asked countless times; however, in my search of this forum I could not find something that seemed to work for something so simple.

**************************************************
Scenerio:

I have 2 forms. The first form is my main form and the second form is my "popup" form. Both of these forms access the same table. In my main form I have it so people can not enter in a ID so it reduces accidental data entry. Therefore, I created a "popup" box that allows ID entry.

Everything works great except when I close out of the popup form, the newly entered data is not available unless I close the main form and reopen.

Million Dollar Question:

How do I refresh or requery (dunno the correct term usage here) the main form to reflect the addition I made in my popup form. I would like the refresh event to happen when I click the close button on my popup form.

**************************************************

Again, I know this is probably simple, but I cannot find it anywhere or most likely I am blind

Thank You

[boblarson]

In the Close event of the popup form, put in

Forms!YourFormNameHere.Requery

Remember to change "YourFormNameHere" to the actual name of the main form.