Combo Box Issue

[gl2295164]

I have created a form that takes information from 4 different tables (No sub-forms). I have a problem with the combo-boxes in that in form-view, I am able to click to see the drop list, however when I click on the choices, there is a "DING" sound and I am not able to click into it. Does anyone know the solution to this? I've been at it for 2 days now!

[RuralGuy]

The ding indicates the field to which the cbo is bound in not updateable. It cound be the entire Recordset of the form is not updateable. http://allenbrowne.com/ser-61.html

[rpeare]

What are you doing on the form, if it's strictly data entry you don't need to link it to other tables, if you want to see the values of what you've chosen (let's say you've chosen a customer) and you want your form to display what that customer's information you'd have to use a lookup query for it to be updatable, but keep in mind any of the lookup fields would NOT be stored on your primary table.

To get a lookup query working you would have to link the parent table to the secondary table (in this case your customers) by the PRIMARY KEY field of the secondary table. So if, in your main table, you are storing the CustomerID you would link that to the customerID field of your CUSTOMERS table and the customerID field would have to be the primary key. Then if you created a query and linked the to tables (join FROM your main table TO your secondary table) and type in a customer ID the fields relating to that customer should auto populate.