Select record in combo and populate textbox

[thmsjlmnt3953]

Hi,

im looking to have a combobox on a unbound form to select a product code (this i can do)
however i want a textbox to auto populate with the description aswell - both in the same table tblproducts - product_id,pcode,pdesc

any help would be fab

 

[plog]

You would use a Dlookup as the source for that textbox. It would look up pdesc from your table based and you would use the value from your combobox as criteria.

With that said, you could have all the information display in that combobox. They aren't limited to showing just 1 column of data. It would look something like this:

P1 | Product 1
P2 | Product 2
P3 | Product 3

This is especially helpful for people not familiar with product codes, that way they get to see the description when they are selecting which one to use.

 

[pbaldy]

Another method:

http://www.baldyweb.com/Autofill.htm

 

[Uncle Gizmo]

Another method you could use is to access the information in the Combobox.

I did a YouTube Video on how to do it HERE:-

MS Access Get Info From a Combobox 1

And here is a set of Screenshots
MS Access Get Info From a Combobox 1

 

[thmsjlmnt3953]

Thanks for replies

multiple solutions and each one great