PLEASE HELP!! Creating report, need to add fields in report from a table based on combo box value i

[buddycheck240]

I'm developing a database that will inevitably be used to print part
numbers and other information onto a 4x6 label for one of our
manufacturing facilities.

There will be a table with all of the part information to be printed on
the label. This is "tblRM". In this table are the fields "SKU",
"Description", "UOM", "Qty", and "Location", where SKU is the primary
key. This table will be filled with information before the users touch
the database.

I have started a simple form with a drop-down box for SKU (which is all
the end-users will need to identify each part) and a text box asking
how many labels the user wants to print. Once the user selects a SKU
from the drop-down list and types in how many labels need to be
printed, they will press the PRINT button and a report will be printed
X number of times.

The following information needs to be on the report: SKU, Description,
UOM, Qty, Location....and all of this information is pre-defined in
tblRM.

***I can easily put the selected SKU on the report, but I need to
figure out how I can pull the rest of the information from tblRM based
on the SKU selected in the combo box found in the form.***

I really really appreciate any and all help. Thanks in advance!

-Bud

 

[buddycheck240]

Is what I'm trying to do here even possible, or am I going about this
the wrong way altogether? Thanks again for any insight,
Bud

 

[Duane Hookom]

Isn't tblRM in your report's record source? If so, you should have all the
fields you are asking to display in your report.

 

[buddycheck240]

Duane - I know this will sound stupid. Where would the code go? In
the report code behind? If I use a query with the above criteria, do I
enter that criteria under the fields SKU, description, UOM, stdQty, and
Location? or just under one of those? I tried adding the criteria and
the report ends up with blank fields behind the text boxes when the
report is generated. I've never had to use the code behind before in
Access, so this is all new to me. Thanks again - I know I'll get this
soon enough!!

Take care,
Bud