M
Mike in Colorado
Access 2003, three tab form with sub forms on tab 2 and 3. On tab 1 is a
control named BookletNo and a second control named Address. BookletNo has
three data validations in the BeforeUpdate event like
If ConditionTrue then
MsgBox
Cancel=True
Me!bookletNo.Undo
Exit Sub
End If
The problem is If the Condition is True, Access locks up after the MsgBox
goes away--the screen has this ugly gray spot where the MsgBox was. Stepping
through the code Cancel=True works, but no Undo. If the condition is false
and the If statement is not used, then Access locks up and will not proceed
to the next control Address. I do not know where the cursor goes--it is not
to be found. Any thoughts as to what is causing the problem?
control named BookletNo and a second control named Address. BookletNo has
three data validations in the BeforeUpdate event like
If ConditionTrue then
MsgBox
Cancel=True
Me!bookletNo.Undo
Exit Sub
End If
The problem is If the Condition is True, Access locks up after the MsgBox
goes away--the screen has this ugly gray spot where the MsgBox was. Stepping
through the code Cancel=True works, but no Undo. If the condition is false
and the If statement is not used, then Access locks up and will not proceed
to the next control Address. I do not know where the cursor goes--it is not
to be found. Any thoughts as to what is causing the problem?