Combo Boxes

[Bvincey2002]

I am creating a form to track all canceld, and return orders. I have one combo box that is named "Cust ID" and a text box named "Company". The Cust ID is the number associated with the company names. I was able to auto fill the "Company" text box with the Cust ID number by choosing the "Cust ID" from the combo box. I would like to show the company name not the "Cust ID". The "Cust ID" combo box is drawing info from a query that has the draws cust and the company name associate with the Cust ID. Could some one help me with this please.

[pbaldy]

Sounds like you need to refer to a different column, like here:

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

[Bob Fitz]

I'm not totally clear about what exactly you want. So, if you want to select and show a name in combo box that is named "Cust ID", change the column widths property. Setting a column to 0cm will make it invisible. However, if you want to select a number in the combo box and then have the Company name that is identified by that number shown in a text box, you will need to set the Control Source property of the text box to something like:
=ComboBoxName.Column(1)
The number in brackets identifies which column of the combo box is to be shown. Remember though, that the first column is 0, the second is 1 etc.

[Bvincey2002]

That expression worked Bob, thank you very much. I do have another issue now. The company name is not being added to the table that the form is bound to? The Cust ID is though. How can I getComapny name to be added to the table? I am newer to Access thank you for the time.

I'm not totally clear about what exactly you want. So, if you want to select and show a name in combo box that is named "Cust ID", change the column widths property. Setting a column to 0cm will make it invisible. However, if you want to select a number in the combo box and then have the Company name that is identified by that number shown in a text box, you will need to set the Control Source property of the text box to something like:
=ComboBoxName.Column(1)
The number in brackets identifies which column of the combo box is to be shown. Remember though, that the first column is 0, the second is 1 etc.

[Bob Fitz]

I do have another issue now. The company name is not being added to the table that the form is bound to? The Cust ID is though.

Good. That is how it should be.

How can I getComapny name to be added to the table?

There is no need to save the name as well as the ID. The tables are for storing data, not for looking at. Although the ID means little if anything to us humans, it should uniquely identify the the company in the companies table. Any time you need details from this table they can be retrieved with a query.

[Bvincey2002]

Thank you! It works.

[Bob Fitz]

Thank you! It works.

Your welcome. Glad we could help.