>I fill a combobox list using .AddList
>
>When a user picks from the list I want to save the Index number of the list item in a 1 character field in my table. For example, the 1st item chosen in my list would save as a "1" in my table.
>
>I tried using .ListIndex and .ListItemID, but no help. It does not change the field in the saved record of the table. How would I do it? Thanks ahead of time.
In the Init of the combo put this code;
This.Value = 1
make sure the BoundTo property is set to .F. Use the ControlSource of the combo to set the field to be updated. These settings make the combo use the ListIndex of the selected item as the value and automatically update the field it has as its ControlSource.