open form and set recordsource

[vicsaccess]

I have a start form with options of running a few differant queries, and a display form with a blank subform, no recordsource. what i envision is that when the user selects a query from the start form i would like to open the display form with the selected query as the recordsource for the subform of the display form. I haven't tried this but just the little bit of research i've done suggest that possibly use OpenArgs could do it. Can anyone point me in any direction, am i on the right path or is there a better way. Basicly the subform of the display form could be one of three differant recordsources. thanks.

[ssanfu]

I don't think OpenArgs will work by passing a recordsource (query), but I could be wrong. You'll have to try it.

Since you would be on a mainform (so to speak - the newly opened form w/subform), you could try this syntax

Me!Subform1.Form.RecordSource = "SELECT blah blah yada yada"

See http://access.mvps.org/access/forms/frm0031.htm



I have heard of having 3 hidden subforms and use Openargs to pass a 1, 2, or 3, then a "Select Case" would set the visible property of one subform to TRUE.

Be aware that the data in a subform gets populated before the main form data.

[vicsaccess]

Thanks Steve, just thinking outside the box on this one while trying to learn something new. My thought was if all my forms are the same except the recordsouce, simple form with a subform, could i just use a singe form and just pass it a different recordsource that is based on the different queries. I guess since they are each based on queries i could assign each SQL a different number on the subforms load propertie, 1="select blah blah from blah, 2=select 1 from blah, and then use your ideal of passing a value with a openarg from the main form. Then a select case on the display form load to define the recordsource of the subform based on the value of the openarg passed? Sounds doable, i'll play with it.

[ssanfu]

What about control sources?
Don't the different queries have different field names in the record sources? Which would mean you would have to change the control source for each control.
Sounds like a *lot* of work/code.....

[vicsaccess]

Good point