I am programming a simple check box in MS Access. This is how it goes:
- I have a combobox set up with a drop down of values the user can choose from.(i.e. b1, b2, c1, d1, d2, d3, e0, e2, etc) They are just 2 character text strings.
- I have a checkbox to be used when the user wants to modify the value in the drop down. Basically all it does is, when the checkbox is checked, it will change any of the values to 'ds(drop down value)" so it just adds the "ds()". (ie. ds(b1), ds(b2), ds(c1), etc)
- If the user unchecks the checkbox, then the value stays as the 2 character text string.
My pseudo code is as follows:
Private Sub distchk_Click() if distchk is checked then Me.ECOSITE = "ds(" & Me.ECOSITE & ")" else: it doesn't modify the ECOSITE field or, if the user hit the check box accidently,
when they uncheck it reverts back to the 2 character text string in ECOSITE End Sub I tested:
Private Sub distchk_Click() Me.ECOSITE = "ds(" & Me.ECOSITE & ")" End Sub but it keeps adding additional ds() anytime I check it, and won't remove it if I uncheck it.
Any suggestions would be great!
Mike