link a combo box to a picture

[Guest]

Hello, I have a form that I enter information into 3 txt boxes and it gives
me an answer in another text box then I click view and it brings up a rpt
that gives me the list of 10 barcodes I need and directions on how to enter
some infor from the form and it shows me a picture of scanable barcodes. What
I want to do is on the form when I select an entry from cboGuage and when I
click to get to the report it will show me the barcode related to the number
selected from the cboGuage list. I have 10 numbers in the cboGuage list and
10 barcodes that coraspond to these numbers. How would I go about doing this?
Can you explain in newbie terms since I am just starting in access...Thanks!

 

[Guest]

You want to show a picture related to an ID on the report?

There are a couple of ways.
1. You could create a sub-report for the items in the table with your
pictures (barcode images). Then drag this to your main report making sure the
Master/Child link fields are set to the ID field that links the records.
2. You could place an unbound object frame on your report and set its row
source and type appropriately, also making sure the Master/Child link fields
are set to the ID field that links the records.

Steve

 

[Guest]

Steve, I want a picture to show up in an image box on my form. I have a table
named tbl_LBStoMLFConversion and it holds two fields. One named width and one
named gauge. I want the image to coraspond with the field named width. On my
form the width is a combo box (cboWidth) that is unbond and the row source
points to that table (tbl_LBStoMLFConversion). I am not using an id in the
table just those two fields mentioned above. My pictures are named the same
as whats in the width table except they have an ext of .jpg. Im new to access
so could you explain further on what you mean? If any more info is needed
just let me know....Thanks!

 

[Guest]

Where are your images, in a table, external files?

If in a table, what is the name of the table and the field containing the
image?
If external fiels, what is the full path to the folder containing your files?

Steve