subform query

[Spyridon]

I have a form and a subform. The form feeds data to a query. On the click of a button, the subform sets it's property to visible. That works fine. What I want it to do is become visible and popluate with the data from the query. Do I need to put a "me.requery" in, and if so, where exactly?

Thanks for any help, I hope I've provided enough information.

 

[scriverb]

You need to requery the main forms subformcontrol. Not the name of the subform itself but the subformcontrol name.

Me![SubFormControl].requery

Post back if you have any questions.

Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[Spyridon]

A million thanks!

Oh yeah, by the way, where would I find the subformcontrol name?

 

[scriverb]

In the forms design window right-click on the subform control and select properties. Select the All tab and scroll to the top. The Name property is the first one in the list.

Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[Spyridon]

he he he... Oh, so it's that simple huh? Thanks, it's working like a charm now Good quote by the way.


Michael

who hopes to some day, within the next 5 years or so, be able to answer some posts on here for people too...

 

[scriverb]

Glad to be of assistance. You like that quote? I loved it when they finally caught him. I am sure his comments then were something like: "I am not Bagdad Bob. He does not exist!!!"

Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???