Combo Box Populates Textboxes

[alyon]

In access 2007, I need a combo box to populate multiple textboxes based on the selected value. Is this possible from a table or do I have to create a query? Can someone give me the code to make this happen? Thank you. :]

[pbaldy]

Like this?

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

[kimmer]

Those are so fun to do. It looks like magic.

[alyon]

Yes just like that. :] only is there any way that I can show no duplicates for Column(2)?

[pbaldy]

Show in the combo or allow in the other table? More details please.

[alyon]

In the combo box show no duplicates. I need duplicates in my table.

I have a combo box I'm trying to show the name in, and it populate the address, and phone number textboxes.

I'm making this program for a small business, so there are over a thousand and some entries because everytime someone enters all the information on the form, it saves it and they need it for their records. However for the combo boxes and textboxes I'm trying to set up like this, it's all contractor information, and it's constantly repeated. So they want to make it simple by the selecting the name, and it automatically filling it in the phone and address, but each contractor name is listed about twenty or more times in the table because it's repeated.

I hope this is enough details. If not, let me know and I will try again.

[alyon]

Oh, and all my information is in one table.

[alyon]

Thank you for your all help :] I finally got it all working. I just set them up through queries. :] Problem solved.

[pbaldy]

Glad you got it sorted out. I assume you either used DISTINCT or GROUP BY?

[alyon]

Actually, no, that didn't work like I wanted it to. So, instead I just selected yes for unique values in the query.

[pbaldy]

If you look at the SQL of the query, that selection added the DISTINCT keyword.

[alyon]

Actually it added GROUP BY to the end. However just adding DISTINCT didn't work how I needed it to because it tried to do sort by the ID number, and not the name. I needed it to sort by the name instead.