to requery a subform from code that runs from within the subform's VBA
module, just use
Me.Requery
to requery a subform from code that runs in the main form's VBA module, use
Me!SubformControlName.Form.Requery
replace SubformControlName with the correct name of the subform control (in
the main form) that contains the subform, of course. make sure that you use
the correct name of the subform control; it may be the same as the name of
the subform, or it may be different.
hth
"Parasyke" <kr************@yahoo.comwrote in message
news:11*********************@f16g2000cwb.googlegro ups.com...
I have a subform within a tabpage that will requery/refresh (?) if I
press F9 and it will update the data in the subform, but I have tried
various combinations of Me!SubformName.requery
Me!Forms!Subformname.requery, etc. to put the F9 functionality into VBA
code but nothing seems to work... any ideas? Thanks!