By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,608 Members | 1,487 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,608 IT Pros & Developers. It's quick & easy.

Find Forms With Subforms

P: n/a
Is there a way to programatically determine if a closed form has one or more
subforms and if it does output the source object of the subform control(s)?
I can't open the form and iterate through the form's controls collection
because the form has an open event that opens a dialog form that provides
parameters to the rowsource of the form.

Thanks!

Steve
Oct 12 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
The open event does not fire if the form is opened in design view, but I
don't think that you expressly need to open it anyway. Iterating through
first the form controls looking for a controlype of acSubform will find the
correct object. Then you must access the form property of the control to
output the source object.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
"Steve" <no******@nomsense.comwrote in message
news:18******************************@earthlink.co m...
Is there a way to programatically determine if a closed form has one or
more subforms and if it does output the source object of the subform
control(s)? I can't open the form and iterate through the form's controls
collection because the form has an open event that opens a dialog form
that provides parameters to the rowsource of the form.

Thanks!

Steve

Oct 12 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.