Combo Box and Option Group to update table

[Katie Howard]

Hi,

I have a form that includes a combo box with a list of customers. It also has an option group that I want to configure to read the data that's in my customer table so that it displays the customer status field and gives the user the ability to change this value.

My problem is that I can't seem to get the option group to see which customer has been selected in the combo box. The form works in that I can run it and set the option to A, B or C, but what it's doing now is just editing the very first record in my customer table.

How do I set it up to look at the customer combo box and refer to that record?
thanks in advance for your help!

[NeoPa]

You need the (code behind the) ComboBox control to apply filtering (See Example Filtering on a Form) to the form before you can then update the selected record.