VLOOKUP type query in Access

[ngan22]

I want to have a field auto filled based on a look up, and I don't know how to do it in Access. Maybe someone here could help.

I have a list of Product Numbers, and their corresponding Descriptions in a table.

I want to be in a form and type in the product number, and have another field auto fill in that corresponding product description.

Thanks in advance.

 

[Andrew Fergus]

Hi, the way to do this is to base the form on a query. The query should include the order information (assuming you are working on an order entry form or something similar) from the order table as well as the product information (including the product description) from the product table.

In your form, create a combo box that looks up the product id and description from the products table (the standard wizard should help with that), and stores the id in the relevant field in your order table. On your form, create a new field that includes the product description from the query, set the locked property to 'Yes' (or enabled to 'No'). When the user selcets a product from the combo box, the description will automatically appear in that field you created and the description cannot be changed.

HTH, Andrew

 

[ngan22]

I have a table named Products.
It has two fields, [Prod#] and [Prod Description].

I have a from named [Form1] and I want to type in that form the product number (say "12345") and have a combo box to the right that looks up the product number and displays its corresponding description (Say "Product VWXYZ").

I am neew to Access and relationships and things, and I have always had a more difficult time getting the results I want from access than getting what I want from excel. Is there a good walkthrough or book that will help me on my way?

Thanks

 

[Andrew Fergus]

Hi, what are you trying to do on the form? After you have selected the product, what do you want to do next? I understand that you want to show the product description, but is there anything else you want to show on the form?
Andrew