Prev: Serial coding
Next: How to add records to a subform from a listbox on a different form
From: James on 8 May 2010 17:04

"James" <nospam(a)please.com> wrote in message
news:j9kFn.378$%u7.22(a)newsfe14.iad...
> From a report print command button on a form, I am trying to check to see
> that a combo box selection was made before continuing.
>
> My code:
>
> If Me![Employee ID] = "" Then
> MsgBox "Please select a Representative!", , "Missed Field Alert"
> Me![Employee ID].SetFocus
> End If
>
> The problem is my code doesn't detect the empty combo box.
>
> Any suggestions appreciated.

Resolved using:

If IsNull(Me![Employee ID]) Then


 | 
Pages: 1
Prev: Serial coding
Next: How to add records to a subform from a listbox on a different form