GoToControl (Macro-Database window)

[T588]

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

 

[T588]

Fixed! Had to use GoToControl twice .....1st to move to subform 2nd to move to control on subform -- I did try this earlier but it didn't work -- probable spelling or I put a space where there shouldn't be one
Thanks
Vince