?
Solved

command not working

Posted on 2014-03-05
2
Medium Priority
?
208 Views
Last Modified: 2014-03-06
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
0
Comment
Question by:gofasteddie
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 39

Accepted Solution

by:
thenelson earned 750 total points
ID: 39908798
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).
0
 

Author Comment

by:gofasteddie
ID: 39909364
Dooh - how quickly we forget.  Tkx.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
New style of hardware planning for Microsoft Exchange server.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question