Hi all. I am a relatively novice user of Access 97 essentially figuring it out as I go, and do most of my work in the Design view (as I am unfamiliar with SQL). I have setup a report that brings information together out of a table (that is regularly updated with a form) and groups the information for our productivity purposes, but I need to limit what is printed in the report to a single criteria (to be set each time the report is run).
The criteria are a set of list names which are rather long and some are elaborate (for example, "ACS South Dakota - 6 Month LONG"
, and setting parameters [Please enter list name (whatever)] each time has become a problem as too many people are entering incorrect spellings, etc., causing no data to be returned in their report. Currently, to help escape this issue, I have them enter keywords by setting the criteria with a LIKE statement,
(Like "*" & [Enter Keywords from the List Name] & "*"
which helps but still has severe limitations.
I would like to set it up such that when the report draws its information from the query, it will ask in a dialog box "which list?" and allow the user to choose from a (drop down style) list of names (which I already have stored in a Table for other parts of the program). Can criteria be selected limiting the user's choice to a predetermined set of information?
If my idea is not a possiblitity based on my limited design-view training, perhaps you could offer some ideas that may accomplish the same goal.
Thanks.
ACSeval -
The criteria are a set of list names which are rather long and some are elaborate (for example, "ACS South Dakota - 6 Month LONG"

(Like "*" & [Enter Keywords from the List Name] & "*"

which helps but still has severe limitations.
I would like to set it up such that when the report draws its information from the query, it will ask in a dialog box "which list?" and allow the user to choose from a (drop down style) list of names (which I already have stored in a Table for other parts of the program). Can criteria be selected limiting the user's choice to a predetermined set of information?
If my idea is not a possiblitity based on my limited design-view training, perhaps you could offer some ideas that may accomplish the same goal.
Thanks.
ACSeval -