Auto Populate Delima

G

Guest

I have a form based on the table Retail Box Detail Master. I am entering the
items being returned in each uniquely numbered box. My form as the following
fields.

Box Number
Item Description
Internal Item No
Quanity Returned
Packgaing Return (each, pack, box, brick)

When the Item Description is typed in the Internal Item No auto populates.
Here is my delema some of our products are names the same, but have different
internal item nos. for example 1 3/4" Firecracker Rolls (i have four of
these each from a different company). When I select in my field Item
Description (combo box based on a query) 1 3/4" Firecracker Rolls with
Internal Item No 539, my Internal Item No field produces the #507 which is
the first of the four prodcuts with the same name.

Why if I specify in the Item Description combo box 539 will it no populate?
 
G

Guest

I do believe your 'Item Description' on your form is a ComboBox with the Auto
Expand set to yes.
Edit your Record Source SELECT statement to include the field for 'Internal
Item No' and increase your column count by one. Also edit the Column Widths
to include display for the additional comuln.

Now when you fill in the description you can click on the vertical selector
and view the item number to select the correct one.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top