Show record source in a text box

[Presto]

I need to weed out a very overcrowded database. I need to remove the queries
that are no longer needed. I need to quickly see the record source for all
the forms. On each form, I already have a subform called "Tasks". I would
like to have the main forms record source listed on that subform when it's
opened. How can I do this? I tried =Me.Form.RecordSource but it doesnt
work no matter where I put it,either on the main form or the subform.

 

[Douglas J. Steele]

If I'm understanding you correctly (i.e. you're trying to show the name of
the parent form's recordset in a text box on a subform), try

=Me.Parent.RecordSource

or

=Me.Parent.Form.RecordSource

 

[Presto]

Thanks Doug, but it keeps coming up with #Name? if I put either example on
the subform or the main form. Either way, it won't work.

 

[Presto]

If I put =[RecordSource] on the main form it will show the query name. I
was hoping to get it on the Tasks subform so I only have to edit one form,
then when I'm done, I can remove it easily.

 

[Marshall Barton]

I need to weed out a very overcrowded database. I need to remove the queries
that are no longer needed. I need to quickly see the record source for all
the forms. On each form, I already have a subform called "Tasks". I would
like to have the main forms record source listed on that subform when it's
opened. How can I do this? I tried =Me.Form.RecordSource but it doesnt
work no matter where I put it,either on the main form or the subform.

Me is not valid in a control expression. The main form can
refer to its own record source using =Form.RecordSource.
The subform can refer to the main form's record source using
=Parent.RecordSource

 

[Presto]

YES!!! =Parent.RecordSource works!! Thank you Marshall! and Thank you
Doug for your input too.

 

[Mike Painter]

http://www.fmsinc.com/ has tools for this.