How do refresh a form?

  • Thread starter Thread starter Jamie Loren
  • Start date Start date
J

Jamie Loren

I have Form1 that is the base for my app. A button on Form1
causes Form2 to pop up. After the user is done with Form2 then
he/she click the OK button on Form2. How can I cause Form1
to be refreshed after the user clicks OK on Form2?
 
Jamie Loren said:
I have Form1 that is the base for my app. A button on Form1
causes Form2 to pop up. After the user is done with Form2 then
he/she click the OK button on Form2. How can I cause Form1
to be refreshed after the user clicks OK on Form2?
Click to expand...

DoCmd.OpenForm "Form2", WindowMode:=acDialog
Me.Requery
 
You can either make form 1 close when form2 pops up and then open again when
form 2 closes,
or
use form.refresh in the form_gotfocus() section of code in form 1.

I prefer to use the second one as it allows form1 to remain open.

HTH
Rhys
 
DoCmd.OpenForm "Form2", WindowMode:=acDialog
Me.Requery
Click to expand...

It was a nice try, but it didn't work. I need Form1 to be
requeried after the user clicks OK on Form2 because
Form2 puts an entry into a table that Form1 needs to see.

Any other ideas?
 
Jamie Loren said:
It was a nice try, but it didn't work. I need Form1 to be
requeried after the user clicks OK on Form2 because
Form2 puts an entry into a table that Form1 needs to see.
Click to expand...

That's exactly what that does, Jamie.

The code goes into Form1.

The first line (the DoCmd.OpenForm) opens Form2 in dialog mode, which means
that you can't do anything else until that form has been closed.

The second line requeries the recordsource for the form.
 
You can either make form 1 close when form2 pops up and then open again
when
form 2 closes,
or
use form.refresh in the form_gotfocus() section of code in form 1.

I prefer to use the second one as it allows form1 to remain open.
Click to expand...

I really thought that was going to work, but for some reason
it just seems to ignore the form.refresh in the form_gotfocus()
section of Form1. Am I missing something? I also tried putting
msgbox "hello" in the gotfocus() section but it doesn't do that
either. It's acting like it is ignoring this section. Any idea what
I am missing?
 
Ignore my advice. I just tested my app and the form.refresh doesn't work. I
thought it did but I still had some old code that did the job in there.

Does it work if you simply reopen the form1 when the button on form 2 is
clicked?
 
Jamie Loren said:
It was a nice try, but it didn't work. I need Form1 to be
requeried after the user clicks OK on Form2 because
Form2 puts an entry into a table that Form1 needs to see.

Any other ideas?
Click to expand...

I assumed from the presence of the OK button on Form2 that it was a dialog
box that would close when OK was pressed. This would be the normal
purpose/behaviour of an OK button. However, if Form2 continues to sit there
after the OK button is clicked (a strange design!) then the quick-and-dirty
way to do it is to put this in the Click event for the OK button:

Forms!Form1.Requery
 
That's exactly what that does, Jamie.
The code goes into Form1.

The first line (the DoCmd.OpenForm) opens Form2 in dialog mode, which
means
that you can't do anything else until that form has been closed.

The second line requeries the recordsource for the form.
Click to expand...

My apologies. I had mistyped the code. Your explanation really
helped alot. Thank you so much. It worked.
 
Awesome thank you.



Baz said:
I assumed from the presence of the OK button on Form2 that it was a dialog
box that would close when OK was pressed. This would be the normal
purpose/behaviour of an OK button. However, if Form2 continues to sit
there
after the OK button is clicked (a strange design!) then the
quick-and-dirty
way to do it is to put this in the Click event for the OK button:

Forms!Form1.Requery
Click to expand...
 
Jamie Loren said:
I really thought that was going to work, but for some reason
it just seems to ignore the form.refresh in the form_gotfocus()
section of Form1. Am I missing something? I also tried putting
msgbox "hello" in the gotfocus() section but it doesn't do that
either. It's acting like it is ignoring this section. Any idea what
I am missing?
Click to expand...

That method makes no sense. If the OK button on Form2 closes Form2, then
the first method I gave you will work if you have implemented it correctly.
If the OK button doesn't close Form2, then merely clicking the OK button
will not cause the GotFocus event to fire on Form1. Use the second method I
gave you.

Also, the Refresh method is not terribly useful. The Requery method is
almost certainly what you want.
 
Back
Top