Checkbox checking for null or blank field prior to msgbox popup not working

[SeadooRider]

The following code works for one checkbox with same code with different checkbox and textbox names, however this one brings up the msgbox even if the required field it is checking DOES have text in it.

CkPhoneListOther is a checkbox
PhoneListName_Pos is a textbox
Both are bound to fields in the table

CkPhoneListOther_AfterUpdate()
If CkPhoneListOther = -1 and Nz(PhoneListName_Pos, "") = "" then
Cancel = true
Msgbox "you must enter a name or position"
PhoneListName.setfocus
End If
End sub
 

Why is it not checking the field to see if it has data?

thanks,
Jason

[Seth Schrock]

In the title, you say you are checking for the checkbox to be null OR the field being blank. Your IF statement isn't checking for Null, it is checking for True. And your comparison is using the AND, not the OR. So I'm not exactly sure what you are wanting. Here is the code that I would use to match your title.

If IsNull(CkPhoneListOther) OR PhoneListName_Pos & "" = "" Then

[SeadooRider]

Sorry, let me clearify. If the checkbox CkPhoneListOther gets checked and the PhoneListOther text field is blank or null, then I need a msgbox to appear. If the PhoneListOther text field is not blank or null then the user should be able to check the checkbox without any msgbox poping up.

Hope that makes more sense
Jason

[Seth Schrock]

Much more sense. Try

If CkPhoneList = True AND PhoneListName_Pos & "" = "" Then