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.
 

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

Similar Threads

Refresh form while Open 6
MULTIPLE FORMS - ALWAYS OPEN ANOTHER FORM... 1
Best way to link popup form? 6
FORM1 ALWAYS OPEN ANOTHER FORM? 1
closing a pop up form2 3
Refreshing Another Form 2
subforms/combo boxes 2
refresh form from the code 4

Back
Top