I have 4 queries and all 4 queries use different tables and pull
different columns.
Is it possible to have one Generic all Purpose form (frmGeneral) and on
the fly at run time set frmGeneral's data source to any of these
queries:
qry1, qry2, qry3 or qry 4 before showing the form to the user?
Once the form is loaded and in view, can the data source be switched on
the fly if the users elects to see the results of another query? I
tried this but when designing the new form the next step was to drag
fields on to the form. I don't want to do this. I just want to change
data sources on the fly.
My whole reason for this is to cut down on maintenance and only have to
maintain one form instead of four near-duplicate-in-appearance forms.
Thanks.
*** Sent via Developersdex http://www.developersdex.com
***
