Refresh form

[nybaseball22]

Hello. I have a form (Form2) with a command button at the bottom to
close the form. This form opens as a pop-up over another form
(Form1). Is there a way I can add to the Close Command on Form 2 a
code that will set the focus back to Form 1 and then refresh that
page?

Thank you

 

[Jeff Boyce]

Another approach might be to have Form1 refresh itself every time it gets
Activated.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Klatuu]

Docmd.Close acForm, Me.Name, acSaveNo
forms!form1.Refresh
forms!form1.SetFocus

 

[Klatuu]

Actually, a better idea, IMHO

 

[nybaseball22]

Ok, I can have it refresh everytime it gets activated, but will this
work if it is already open, a form opens over it, then the form over
it closes? Does this Activate the form again?

If so, I assume it would be Me.Refresh

Thanks.