Look Up Combo Box

[danielemyr]

Hello,

I was wondering if you could help. I have a combo box that looks up a product number form another field but i also have a combo box in the next field that has product name. It would be much better if once you select a product code that the product name comes up automatically. I am quite new to this and have pretty much bluffed my way through my database so far so I'm not sure if this possible but if anyone could help it would be much appreciated.

Thanks

 

[plog]

2 options, the first is exactly what you want described:

You set the source of the Product Name field to a Dlookup (http://www.techonthenet.com/access/functions/domain/dlookup.php) that takes the value of the Product Code field and gets the Product Name from your table/query that has that data.

The second way is cleaner--You make the product code field a drop down box that lists all the available values and also shows the Product Name next to it. This eliminates the second box (Product Name) completely. For this, you set the drop down box to feed off a query which has the Product Code as the first item and the Product Name as the second.