expressions referring to tabbed subforms

E

Ericksc

Hello,
I have a subform on a tab in datasheet view. There is also a button on this
tab which opens up a form which populates the table the subform is driven
from. I would like to have the subform auto-refresh after the populating
form is closed, but can't figure out how. I think most of my trouble is that
I don't know how to write an expression referring to a tabbed subform. is it
"mainform!subform.form"? or is it something else? Help!?
 
E

Ericksc

So is the expression i'm using correct? or do I need something else? What
event would be good for this?
 
K

Ken Snell [MVP]

If you want to requery the subform, use this:
Me.Subform.Requery

where Subform is the name of the subform control (the control that holds the
subform object).
--

Ken Snell
<MS ACCESS MVP>
 
Top