Goto Control

[SteveE]

I use a macro to check if a field xxx has been entered if not a message tells the operator to enter detail and sets the focus back to the empty xxx field.
This works fine sometimes but other times it returns and error stating there is no field named xxx in the current record, why would this happen?

any help appricated.
[Forms]![arrivalsnew]![BOOKREF] Is Null MsgBox
[Forms]![arrivalsnew]![BOOKREF] Is Null GoToControl

Control Name BOOKREF

 

[SteveE]

Go to Control **Cancel**

Sorry dont know why I used a macro in the first place, I have reproduced the action in VBA and it works fine, stii wonder why it worked sometimes and not other in a macro though

Steve