Adding fields to combo boxes after the fact

[hrseebeck]

Hi everyone. I have a very simple item I would like to do; however, it doesn't seem to be working properly. I have a QuoteProducts table that has a combo box for the Product Number showing columns for Product Number, Product Name, Description, Size, and UOM from the Products table. Each of these fields are used in my form to pull in the data using =[ProdNo].[Column](X). I need to add a new column in the combo box called Description 2 so that I can pull the additional description into my form by the same formula. I have added the field to the Products table, and gone into the QuoteProducts table and added the Desc2 field to the query for the combo box at the end of the query; however, when I go to my form and enter the formula in a text box using the formula nothing is pulling up. The combo box has the following columns from the Product table: ID, Product Number, Product Name, Description, Size, UOM, Price, and Desc2.

Any thoughts?

Thank you for your assistance.

[pbaldy]

Typically the column count and column width properties need to be adjusted.

[ssanfu]

I have a QuoteProducts table that has a combo box for the Product Number showing columns

are you referring to a combo box control on a form or a look-up field in a table?
If you mean a look-up field , you should read about the evils of look-up fields >> http://access.mvps.org/access/lookupfields.htm

[orange]

You are telling HOW you do something or wish to do something. Can you describe to us in 4 or 5 lines WHAT it is you are trying to do -- plain English please? If we are to help you, we have to understand your issue with your database and your environment. You can see from the responders that we don't yet "understand" WHAT you are trying to do.

[Missinglinq]

As Paul suggested, it sounds as if you forgot to increase the Column Count for the Combobox, to include the added Field, and you will also need to modify the ColumnWidths Property, as he said.

Linq ;0)>

[pbaldy]

I must not say things well enough.