Refreshing a form when redisplayed

[Guest]

I have a form [form1] that displays a list of tickets in a subform. There is
a button on Form1 that brings you to Form2 which allows you to Add a New
Ticket. When you exit Form2 you are brought back to Form1.

Is there anyway to automatically Refresh Form1 after closing Form2?
Currently I have a "Refresh" button on Form1 that you have to click to
display the newly added ticket that was added using Form2!

Hope this all makes sense.

Thanks in advance for your help.

 

[George Nicholson]

Assuming there is a "Form Close" button Click event (or something like it)
on Form2:
- Check that Form1 IsLoaded (in case you ever decide to use Form2 without
Form1)
- If Open, Refresh/Requery Form1
- In all cases, Close Form2

Alternatively, you could check out the Form_Activate event. It should fire
when Form2 closes and returns focus to Form1.