Change Recordsource on A Subform

[Learn2010]

I know this is probably already in the forum but it is getting pretty big and I can't find the answer. I have this:

frmMain frmMainSub frmMainSubSub recordsource = query1

How do I change query1 to query2? I hope this makes sense.

Thank you.

 

[pr2-eugin]

frmMain frmMainSub frmMainSubSub recordsource = query2 ??

No ! It does not make much sense. Explain what you are doing and when you want this to change from query1 to query2.

 

[Learn2010]

frmMain has a subform, frmMainSub. I change the sourceobject of frmMainSub for some procedures with this:

Forms!frmMain!frmMainSub.SourceObject = "frmMainSubSub"

frmMainSubSub can be any of several forms. On one form I have buttons to see different views of the data. The default view recordsource for this version of frmMainSubSub is query1, which displays the records in descending order.

I need to click the button on that form to view the records in ascending order, that is, use query2 as the recordsource instead of query1.

Thank you.