Trying to make two buttons that can auto make Queries and Reports based off inputs on a Form

[Fealor]

So I have made a form that looks like a Wizard. This "Wizard" is for easy of use for our customers to make Reports and Queries. The "Wizard" has input boxes for the Table, Fields, certain dates (default should be all available dates), and Title of the output. What I need now is for two buttons at the end of the "Wizard" to output a Query or Report. I tried looking for a macro that could do this, but no luck and my VB skills are lacking. Can anyone give me advice on where to start or help on the coding?

Thank You!

[ranman256]

dont make hundreds of queries,instead,
make a continuous form that shows all records.
In the header, put unbound controls for the user to enter search criteria.
When user clicks the Find button, Test all controls for a possible filter then build the where clause:

sub btnFind_click()

sWhere = "1=1"
if not isnull(cboState) then   sWhere = sWhere & " and [state]='" & cboState & "'"
if not IsNull(txtName) then    sWhere = sWhere & " and [Name]='" & txtName & "'"
if not IsNull(cboGender) then    sWhere = sWhere & " and [Gender]='" & cboGender & "'"

 'then filer
if sWhere = "1=1" then
  me.filterOn = false
else
  me.filter = sWhere
  me.filterOn = true
endif
end sub