Good morning all,
Appreciate the help! I have had a quick search but couldn't find this one. I'm sure it'll have been answered before though.
Issue: Unbound text box does not display data when form loads and does not update when switching between records on the form.
Form Name: Frm_ExposureMaster
Form Type: Single Form
Bound Combobox: cmbPipeSize
Unbound text box: TxtPipeDetails
TxtPipedetails is set to show columns 1 through 5 of cmbPipeSize, so the event procedure on cmbPipeSize is set to:
Thanks,
Morphies.
Appreciate the help! I have had a quick search but couldn't find this one. I'm sure it'll have been answered before though.
Issue: Unbound text box does not display data when form loads and does not update when switching between records on the form.
Form Name: Frm_ExposureMaster
Form Type: Single Form
Bound Combobox: cmbPipeSize
Unbound text box: TxtPipeDetails
TxtPipedetails is set to show columns 1 through 5 of cmbPipeSize, so the event procedure on cmbPipeSize is set to:
Code:
Private Sub CmbPipeSize_AfterUpdate()
TxtPipeDetails = CmbPipeSize.Column(1) & Space(20) & CmbPipeSize.Column(2) & Space(20) & CmbPipeSize.Column(3) & Space(20) & CmbPipeSize.Column(4) & Space(20) & CmbPipeSize.Column(5)
End Sub
Thanks,
Morphies.