parameter from query runs report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All, I did a paramenter fin my query to run a report by study, is there
other way to do it? I am new to Access, and based on searches, I put a
paramenter on studyname field at table study, run the queryworks well. But I
would like a list/or combo box on the query and report, instead of remember
the name of the study(It can be long numeric and confusing, have adrop list
and choose from there. Tia
 
Savanah said:
Hi All, I did a paramenter fin my query to run a report by study, is there
other way to do it? I am new to Access, and based on searches, I put a
paramenter on studyname field at table study, run the queryworks well. But I
would like a list/or combo box on the query and report, instead of remember
the name of the study(It can be long numeric and confusing, have adrop list
and choose from there. Tia
Click to expand...

Please re-read John Vinson reply in your thread OH NO!

gls858
 
Hi All, I did a paramenter fin my query to run a report by study, is there
other way to do it? I am new to Access, and based on searches, I put a
paramenter on studyname field at table study, run the queryworks well. But I
would like a list/or combo box on the query and report, instead of remember
the name of the study(It can be long numeric and confusing, have adrop list
and choose from there. Tia
Click to expand...

You can use a Form to select the study.

Create a little unbound form, let's call it frmCrit. On it put a Combo
Box (also unbound) named cboStudy selecting the study ID's (or names,
if you've unwisely stored the name in your table).

Create a Query with a criterion

=[Forms]![frmCrit]![cboStudy]

on the appropriate field.

You can then base your Report on this query, and put a command button
on frmCrit to open the report. There's no need to "run the query", or
even to see the database window at all; when you launch the report
from the button, it will use the criterion on the form, and display
the selected results.

John W. Vinson[MVP]
 
Back
Top