Refreshing a form when redisplayed

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top