Requery an open form

[Simon]

I have a form frmOrder, i have a button on the frmOrder that opend up
a subform (frmOrderSubform )
on my subform i have a Close button

On the close button i would like to also requery the frmOrder

What would the code be to requery another form that is already open


Thanks

 

[boblarson]

That would be:

Forms!frmOrder.Requery

--
Bob Larson
Access MVP
Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________

 

[Steve Schapel]

Simon,

Notwithstanding Bob's reply, which I think is what you want, I was
myself having trouble understanding your question. But now I suspect it
is because of your use of the word 'subform' to mean something different
from what it normally means in Access. A subform is a form that is
embedded within another form. You can't "open" or "close" a subform. I
think what you mean is "another form". Am I right?