Form wont add data from a combo box

[bopsgtir]

Hi again, one a one of my forms i have a drop down box to choose from but when you click on any of titles from the combo box nothing appears and it wont let you complete the record, do you know why this would be??

[RuralGuy]

It sounds like your ComboBox is bound (has a control source) to the RecordSource of the FORM and *that* RecordeSource is not updateable. http://allenbrowne.com/ser-61.html

[bopsgtir]

Sorry am a still confused on how to fix it.

basically the form is used to add a vehicle to my vehicle list, one of the options on the form is a combo box to select which hire company the vehicle has come from, this combo box is bound by the vehicle leasing table. but i still dont see why it wont select any of records from the combo box

[RuralGuy]

What is the RecordSource of your FORM? If it is a query, can you open the query and change anything directly?

[bopsgtir]

The Record Source is the table Vehicle, i know i can just add to the table but i want all of this done through forms

[RuralGuy]

I was just trying to determine if your RecordSource was updateable. And chance you can post your db so we can look at it. It would speed up the resolution. Compact and Repair first and then zip it before posting.

[bopsgtir]

please find attached the db.

[RuralGuy]

Your ComboBox RowSource has one field being pulled but your BoundColumn was set to 2. Change the BoundColumn to 1 and see what happens.

[bopsgtir]

Thank you that all working now

[RuralGuy]

That's great! Thanks for posting back with your success.