Auto Insert Field Info Based upon Combo box

[aikiai]

Someone once posted an database on how to do this but I was not able to see how they were able to automatically input the data into a text field.

I know how to do a combo box to query and input those results into a combo box but I am confused how they got the information from the combo box selection to automatically put the other variables into the testbox. They did this without using the dlookup command. In fact it was done without any code.

They showed how to do this automatically without code and with two other methods (one being dlookup). Can someone please help me if it is clearcut as I don't have too much time to search the forums for empty answers (believe me I have already wasted too much time) Thank You

 

[MStef]

Hello aikiai!
Look at "DemoCBoxTA97.mdb"

 

[uplink600]

MStef

I got this working in my db using the combo but I would like the selection to be in a textbox. I need the user to enter an account number in txtAccountNumber and for the customer name to automatically appear in txtAccountName.

I've tried to play arround with your example db but can't seem to get it to work.

Thanks

VC

PS aikiai, aplogies for using your thread, hope you don't mind. Thanks.

 

[MStef]

Hello uplink600!
I don't know exactly what you need.
Send a short example of your mdb (form, table),
maybe I can do something.

 

[aikiai]

MStef

I got this working in my db using the combo but I would like the selection to be in a textbox. I need the user to enter an account number in txtAccountNumber and for the customer name to automatically appear in txtAccountName.

I've tried to play arround with your example db but can't seem to get it to work.

Thanks

VC

PS aikiai, aplogies for using your thread, hope you don't mind. Thanks.

No problem. By the way, does this forum have any way to have stickys or some type of faqs that address common issues like this as I know this has probably been asked multiple times? Or is there an excellent online guide somewhere that addresses common how-to situations?