Look ups in an Access Form

[flubbs]

Hi - I have created a form and when I type in the value I need ie a Sku/product code I want it to bring up the description in another box. Also does the other box need to be created as a combo or a text or even list? thanks

[jzwp11]

Welcome to the forum!

If you bring the data in via the combo box, you can add other textbox controls to the form that reference the other columns/fields brought in via the combo box using the expression =comboboxname.column(x)

x=the number of the column of the combo box's row source that has the info you need. Access starts numbering at zero.

So if your row combo box's row source is as follows:


SELECT empID, EmpFName, EmpLName

and you want to display the employee's last name in a textbox on the form, you would use this expression

=comboboxname.column(2)

[flubbs]

Thanks for this. But im struggling.

Once I have created my Combo box that will allow users to pick the sku, what kind of box do I work from then to pick its descrption?

[jzwp11]

You will need a text box control and set the control source with the expression. Per your e-mail, if the combo box name is combo4 the expression would look like this

=combo4.column(x)

You'll have to specify the number for the x.

I've attached an example database to help illustrate.