Query Assistance needed please.

[cnut1]

I have DB with a Switchboard that has a button for Bin Number (Part Number). It is based on a parameter query that asks you to input your Bin Number. Once you enter the Bin Number it pulls all information for that Bin Number from a table that contains the Bin Number, description, Manufacturer P/N and Manufacturer and shows this in the query.

What I need to do is have this information each time a different Bin Number is entered to be stored in specific table (datasheet style) for printing out just a list of specific Bin Numbers and their information. As the parameter query stands now, each time I input a different Bin Number it clears the previous information. Can I tie in a make table query in some manner that will store the selected Bin Number info?

Can someone make suggestions on the easiest and quickest way to set this up? Keep in mind I am still learning Access so please be detailed in your comments. Thanks in advance for any assistance.

 

[Smart]

I would create a report based on your query that asks for a bin no.
The report will contain the relevant detaoils and can be printed
then enter a new bin number when you run the report again and so on

 

[neileg]

I would use a temporary table. Create a continuous form bound to a new table for the user to enter all the Bin Numbers. Use this table in a query that joins the temporary table to the main table and base your report on that. Make sure that you delete the records in the table so that it is empty for the next report. Don't delete the table.

 

[cnut1]

Neileg
Not sure I am clear on what you are describing. All the Bin numbers, descriptions, etc. were on a spreadsheet in excel and imported into Access creating a table with all this data already in it. Working from this table what would I need to do other than create the form with bound forms to this table? Is there a query I would need to create that would store the data in the temporary table?

 

[neileg]

Here's a quick sample. It's very rough but I hope you will see what I mean.

 

[cnut1]

Neil
Thanks for the example. That helps me greatly since I am more visual in the way I learn. I will work on it and let you know how it goes.