Newbie, seems simple to lookup value?!

[ayce123]

I have a table with two columns in it: a text description and a corresponding numerical code.



I have a form that has a combo-box containing all the text descriptions in it. I am trying to make it so that the user selects a descriptor and Access automatically pulls the corresponding numerical code into another field right next to it. I need to save the specific descriptor and code the user picked into a separate table. Thanks for the help! Sorry, first post, please let me know what other info would be helpful in making this work.

[pbaldy]

You typically would only store the numerical code in the other table, but:

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

[ayce123]

Thanks! That's exactly what I needed. Works like a charm.

[pbaldy]

Happy to help, and welcome to the site by the way!