Automatically populate parameter in a query??

[SPRTRMP]

First off, PLEASE bear with me. I am a total NEWBy to access and know ALMOST nothing about what I am about to ask.

I am in the process of building a database to track publications (529 total). I have 3 different ways to allow users to find a pub. the first 2 involve unique numbers that the users will know, and I have queries set up for those. The third way involves having the user "walk through" a sub-categorized series of links to find the exact pub they are looking for. When the user reaches the final link and clicks on it, that link SHOULD run a query that compiles info from various tables onto a form.

I have designed the form and the query to get the info from the various tables, with the criteria set to prompt the user for the ID (AutoNumber)but need a way for each of the "final links" to run the query with the ID already set, not requiring the user to enter the ID number: that number would already be "embedded" in the link, and the query would run with no input required from the user.

Also need that info to be displayed on a pretty little form... PLEASE HELP!!!

 

[pbaldy]

You can have the query criteria be a form reference instead of [Enter blah]:

Forms!FormName.ControlName

Presuming your walk-through results in a control (textbox, combobox, etc) with the ID in it, that would be the way to go.

 

[SPRTRMP]

again, sorry i am a complete novice at this, but...

my walkthru doesnt result in a combobox\textbox, but is just a form with a list (labels) of the different publications (trying to make this as user-friendly as possible, considering who will ultimately use it). i am trying to set it up so that the "OnClick property of the label runs the query, blah, blah, blah...

where would you put this "form reference" you suggested, and given that it is just a list of static labels, is there a way to associate each label with a different ID number?