auto fill look up text box

[macri]

OKOKOK

I'm trying to have a text box on a form look through my product# field for an exact match ie if i type 123456 it looks for the product# 123456 and then in the text box below it i want it to put the data from the cell to the right which is my product description.

basically if text1 = a:a text2 = b:b

also i hate ms access and wish my boss would let me do this in mysql with php in the mix unfortunately open source to him means "anyone can hack it"

 

[pbaldy]

It would be simplest to do with a combo box:

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

If you want to do it with a textbox, you'd either open a recordset or use DLookup to get the value out of the table.

 

[macri]

Thanks for getting back to me so quick, i tried using the documentation you linked me however i find this program to be very confusing i wish i could just hard code it...

here is an example of what i have
prd code...prd description
1........... ice cream
2........... china
3........... paper clip
4........... pepsi
5........... cream corn

i have changed product description on the form to a combo box as you suggested which links to prd description so they're all in there i checked which is great what i'd like to do is have it so i type in 4 into the text box then in the combo box below the description populates ie if i type 3 the combo box jumps to paper clip... your documentation may have explained it perfectly but i'm really terrible with most microsoft software as i haven't used most of it since high school. i learned on 2000 and things clearly have changed since then lol as they probably should have i remember crashing access fairly often in class lol

 

[pbaldy]

My example would work the opposite. The user would make their selection in the combo box, and the textbox would fill with the other value. That let's the combo do all the work of looking up related values.