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!SubformContr olName.Form.Req uery
replace SubformControlN ame 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******** *************@f 16g2000cwb.goog legroups.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!Subfor mname.requery, etc. to put the F9 functionality into VBA
code but nothing seems to work... any ideas? Thanks!