Link to home
Start Free TrialLog in
Avatar of cers4686
cers4686

asked on

bound combobox value doesn't change

I have a combobox cboBackEnd that is bound to BackEndID in tblKeepingTrack.
When a user clicks on btnChangeBackEnd in code I have the following in code:
Me.cboBackEnd = IIf(Me.cboBackEnd(2) = "Local", 3, 2)
(In my tblBackEnds, 3 is the ID for the Server BackEnd and 2 is the ID for the Local Backend)

When I click the button, I see the value of the combobox change on the form, but when I exit and return to the form, the old value still shows up in the combobox. When I change the combo by hand, however, then the value is saved. How can I save the value when the user clicks the button?
Thanks.
ASKER CERTIFIED SOLUTION
Avatar of GRayL
GRayL
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial