SubForm RecordSet properties

[W.Dnx.W]

So far I had several Subforms which would open in a mainForm depending on the combo box value. My combo box values were exactly the same as subform names so that I can easily change subform.recordsource = combo.text and it would show the proper form. Now, I'm thining, instead of having all those forms, I could have only one form and just changing it's recordSource property with the sma combo box, but this time, combo.value would be the name of the SQL string that the form needs to take as it's recordSet.

What I want to know is, if this will work at all, and if it would, where do I have to set my vars...in the Form_load()?!

tnx

D

 

[W.Dnx.W]

Never mind this one...I somehow found the solution for my problem...thanks everyone...
D