Refeshing Data in a Parent-Child Subform.

[Rickmister]

I have created a form with a parent-child relationship. I am using a subform that needs to be refreshed on command. I

need some VBA code that will refresh the data in the subform to reflect immediate changes made.

I've tried several pieces of code, but have had no luck as of yet.

Thanks in advance.
- RS

 

[krsherm]

Requery the parent form, and it will automaticall requery all children. Assume the main form is named "frmMain"... use this code:

Forms!frmMain.Requery

Hope that helps...

Rock ON!

Kevin

 

[RottPaws]

I believe the syntax to requery the sub form is:

forms!MainformName!SubFormControlName.form.requery

If that's not it, it's something close to that. Let me know if it doesn't work and I'll look it up at work tomorrow. _________
Rott Paws

...It's not a bug. It's an undocumented feature.