In the designview of a macro from the database window - I have several GoToControls that display mesage boxes if controls are null - the last control in the series is on a subform and the messagebox works fine but the focus will not move to the control on the subform - I tried several actions ie: GoToRecord, OpenForm ect - I can't get it to work.
These are the last 2 in the series
1) IsNull([Forms]![Order]![ShiptoName]) MsgBox
2) ... GoToControl
3) ... StopMacro
4) IsNull([Forms]![Order]![Order Subform]![Product]) MsgBox
5) ... GoToControl
6) ... StopMacro
Works up to #4
Thanks Vince
These are the last 2 in the series
1) IsNull([Forms]![Order]![ShiptoName]) MsgBox
2) ... GoToControl
3) ... StopMacro
4) IsNull([Forms]![Order]![Order Subform]![Product]) MsgBox
5) ... GoToControl
6) ... StopMacro
Works up to #4
Thanks Vince