I'm trying to get a msgbox to inform user that, if there is no Serial (Item selected) for the specific Sale, there needs to be a Item selected before you can indicate "OK to Pay."
The checkbox already has some enable/disable items; I've inserted new instructions, but it's not working. The Serial field doesn't have a default of "0", it would be blank if there's no Serial selected. I tried Null, >0 with no success.
Private Sub OKtoPay_Click()
If OKtoPay.Value = vbChecked Then
Combo218.Enabled = False
Else
Combo218.Enabled = True
End If
If (Forms!frmSales!Serial >= 0) Then
MsgBox "A Kirby is not assigned to Sale.", vbExclamation, "BizTrack"
Combo218.Enabled = False
OKtoPay.Value = 0
End If
End Sub
Any help would be appreciated.
Start Free Trial
