I have a form, it calls a pop up form with a text box in it called txtReason,
as well as a password field.
If the user goes to enter a password without putting a reason then I want it
to MsgBox them to put in a Reason.
The pop up form has no record source. txtReason is unbound, I just need the
value after I close the pop up but it must be entered.
With the code I currently have below in my Password text box Before Update,
when I Debug, it shows txtReason = Null, and Null = Null yet it skips over
the If and goes to the End If, completely baffling me.
If txtReason = Null Then
MsgBox "You must enter a Reason", vbOKOnly, "Message Alert"
Message posted via AccessMonster.com