Originally posted by AZ KC
In the afterupdate event
if not isnull(me!cboCo) then
me!txtCk = me!txtCk & ", " & me!cboCo
This appends the comboboxes contents to textbox with a comma if there was a selection made. It will run as many times as the user makes selections.
Ok,, alls well, but....
If the person entered a value by accident and then wants to change it i handled that,,, but my new value wont show in the Txtbox, only if i go to design view then form view will the correct data show
If Not IsNull(Me.cboCompany.Value) Then
If Not InStr(Me.CheckNum.Value, "-") > 0 Then
Me.CheckNum = Me.CheckNum & "-" & Me.cboCompany.Value
Me.CheckNum = Left(Me.CheckNum, InStr(Me.CheckNum.Value, "-") - 1) & "-" & Me.cboCompany.Value