Need help loading values

[ismith]

Hello,




Ive got a form with bound txt boxes. these look into my 'Product' Table and show the last product entered. Now ive got a search button on the same page.


When you clcik the search button a combo box appears which has in it a list of all the values in the Product table.


What i want to do is when the user clicks any value from the combo box,
the txt boxes should populate with information for the values that have been chosen.


Example:


My combo box shows 3 values, ProductID, Description and Size.
if i choose prodID 3 i want all the txt boxes to change to the infomration that is contained in that row.



Anyone know how i can do this?



Thanks...

[Stingaway]

Quite a few options - one that comes to mind if you don't want to do it through code is a sub form with the table information in it, driven and filtered by your combo box on the main form.

[ismith]

Quite a few options - one that comes to mind if you don't want to do it through code is a sub form with the table information in it, driven and filtered by your combo box on the main form.

How would i do that?

Im fairly new to access and vba.

thanks..

[alansidman]

This solution might work for you.

http://www.datapigtechnologies.com/f...tomfilter.html
or perhaps this one.
http://www.datapigtechnologies.com/f...subforms1.html

Alan