list forms subforms and recordsource

[Jaye7]

so I have a commandbutton on a form, when I click on the button I would like an inputbox that lists the subforms and subforms recordsource/ controlsource.

 

[Mihail]

Not possible with an input box.
design a form for this task.

 

[Jaye7]

OK, I can deal with that, so what I need is a script that lists the forms and subforms recordsource and control sources in a textbox1.

 

[Mihail]

http://www.consultdmw.com/access-VBA-list-objects.htm

 

[Jaye7]

Thanks Mihail, I can work with that.