One Form-Change Recordset to Different Queries on Click

[gyli84]

Is it possible to have a form whose recordset can be changed to that of a different query. I have lots of different queries all with the same fields but different criteria and what I would ideally like to be able to do is to have ONE form and then click a button (one for each query) which would then change the recordset of the form to that specific query and would run the query you would enter the criteria in the dialog box and the information on the form would be displayed. If this is possible how can it be done and what code is required?

Thanks

 

[Jack Cowley]

Behind each button put code like this:

Me.RecordSource = "MyQueryName"
Me.Requery