Hello,
I've had a look thru some of the forums, but nothing to match my current error if I could get some advice please.
I have a check box and then a combo box.
On form close I go thru some checks to ensure certain fields are filled out correctly.
This particular one is given me grief. Run-time error 13 Type mismatch
I select "Skilled Labour" try and close and then code activates as combo box has nothing in it.
Works, all good, happy days.
However, when I select items in the combo box and try to close, I get the error.
Thank you
I've had a look thru some of the forums, but nothing to match my current error if I could get some advice please.
I have a check box and then a combo box.
On form close I go thru some checks to ensure certain fields are filled out correctly.
This particular one is given me grief. Run-time error 13 Type mismatch
I select "Skilled Labour" try and close and then code activates as combo box has nothing in it.
Works, all good, happy days.
However, when I select items in the combo box and try to close, I get the error.
Code:
' Check Skilled Labour Combo box
If (ChkSkill = True) Then
If Nz(Me.CboSkill) = "" Then
txtmessage = "Skilled Labour has been chosen for this Job, Please Select Type of labour" & vbCrLf & txtmessage
Me.CboSkill.BackColor = vbRed
Me.CboSkill.ForeColor = vbWhite
Me.CboSkill.SetFocus
Else
Me.CboSkill.BackColor = vbWhite
Me.CboSkill.ForeColor = vbBlack
End If
End If
Thank you