populating a subform with one of many queries

[Boomshank]

hello,

I am trying to create a form that uses a subform to display the reults of a query, my problem is that i have 5 queries for the user to choose from.

Is there any way that i can use the one form and populate the subform with the users chosen query or do i need to create a form for each query?

Many Thanks

 

[MarkK]

Check into the the RecordSource property of the Form object. For multiple data sources--including tables, queries and SQL statements--having the same fields, you absolutely want to be able to use a single form and change only the RecordSource.