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!!!
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!!!