Entry Data to combobox that will supply the corresponding Data to a textbox or field

[mykil]

Hi Folks, I'm Still new in making access database and I need your help. Is it possible to have a combobox that has a corresponding data to a textbox or field. what i mean is that when you enter data in the combobox it will show its corresponding data in a textbox or field. For example: if I entered "PASSED" in the Combobox1 it should automatically supply the data in textbox1 which is "1.0"...
Combobox1 = PASSED will result to Textbox1 = 1.0

any help will be appreciated, thanks a lot

 

[MStef]

I think you need something like "DemoComboB3A2000.mdb"
(attachment, zip). Open Form1 and try.
Adapt it as you need.

 

[mykil]

Thanks for the sample but it doesn't yet solve my problem. what you have showed in "DemoComboB3A2000.mdb" form is a combobox that will search for an existing record. Am I right? What I want is not to search for an existing record but to filled up the data I need. I mean, when I type or Select the Data from a Combobox "Value List" it will show the equivalent value to my Textbox. Do you know how to do that? If so, Please Help me. because i need it most

Your help will be much appreciated

 

[MStef]

Ok, here it is. Look at "DemoComboValueListA2000.mdb"
(attachment, zip).
Look at Form1 (VBA), via Value List -combo,
look at Form1c (VBA), via Table2 - combo.

 

[mykil]

Nice One. I've got it now.. Thanks very much