Auto Completion on forms

[IPconfig]

hello access guru's

i got a small problem here , i am using Access 2000 and i have 2 tables a Products table and a Customers table , see what i want to do is this on the customers table i have 2 fields which i also have in the Products table , one of the fields has a combo box which should be tapping the info within it from the Products table so when you click on one of the options it automatically auto completes anything that was tapped from the products table/form so that you dont go through the hassle of putting in the info manually , Now my question is how can i make this happen ..can someone walk me through this or give me a couple of hints ..!!

all help is highly appreciate it

 

[jgoodman00]

You will need to add some code in the afterupdate event of your combo box. This will need to set the remaining fields (which are relvant to the products table) to carry out a Dlookup based on the value in the first combo box.
e.g

Me!txtPrice = Dlookup("[Price]","[tblProducts]","[ProductID = " & Me!cboProduct)


Hopefully this will accomplish what you are trying to do...
James Goodman
j.goodman00@btinternet.com