Lookup values after entering data in form

[Hulkdog]

This one should be an easy fix, but I am brand new to Access.

Access 2010

I have a form with a text box entry where you input an inventory code for shipping.

Example XX????? for X being the letters and ? being the numbers

I have 3 tables listing all of these codes in separate categories and the information of the items they represent.

Question:

How do I auto-fill on the form, the additional data from these codes. And is it possible to have this data saved in the shipping table, or does it only display on the form. (It is ok if this data won't be saved)

Thank you for all your help!

[pbaldy]

Does this fit your needs?

BaldyWeb - Autofill

[Hulkdog]

Not exactly, although I did try this and I will remember it thank you very much!

I have for example:

A code for a product X15 that I have received from the vendor.
I have to enter this in a received table, with a bunch of other info.
I also have a table which lists only, all the codes, and their item Names... like "pumpkin"
When entering data on the form associated with the receiving table, is it possible to enter the code, and have the combobox display the name (and maybe save it into the table)