How to update record with combobox selection

[vector39]

Hi everyone

Does anyone know the VBA needed to update a record from a combobox selection? I have form where users can enter new company information and I have a combobox that lists all items from one field in the main table. However whenever a user makes a selection, the record updates except for that one field. And I'm assuming it has to do with the After_Update event procedure in the combo box's property sheet. I tried things like:

Me.Combo596.ListItem = True


or
Combo596.value = Combo596.Listindex(0)

But so far, nothing has worked. Thoughts?

[aytee111]

Add the table field name as the control source of the combobox.

[vector39]

Add the table field name as the control source of the combobox.

Thanks for the reply. I did so and I notice every time I make a selection a number appears instead of the actual value. Any idea why this is?

[orange]

Here's a link to all kinds of information and examples for Comboboxes
It seems you may have an issue with the bound field,but most likely the display columns widths. (best guess)

You are not using lookup fields at table field level, right?

Good luck.