command not working

gofasteddie
gofasteddie used Ask the Experts™
on
The GoTo.Next command is working from the ribbon.  The GoToRecord.Next command is not working from a macro.  Database created in a trusted location.
macro1.PNG
macro2.PNG
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
The goto command using the macro is not working because the macro has the focus. For the goto command to work, the form or report has to have the focus. You need to call the macro from vba or a control event for the macro to work. Create the macro, then set an event for one of your control events to the macro (a button click event for example).

Author

Commented:
Dooh - how quickly we forget.  Tkx.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial