Results 1 to 2 of 2
  1. #1
    JrMontgom is offline Competent Performer
    Windows Vista Access 2010 32bit
    Join Date
    Sep 2012
    Location
    Vero Beach, FL USA
    Posts
    124

    How to use macro to go to next record in a form with a 1:Many relationship

    I used the Control Wizard to create a macro on a command button to do record navigation i.e. go to First, Next, Previous and last record. The macro code, in the macro editor, is inserted on a command button on the form, asks whether it is a table, query form etc. I chose form and entered the form name but the error says the form needs to be open before I can run the macro. This happens when I open the form from a Navigation Control and Click the button containing the Macro code on the form.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    Here we go again, this issue has been seen several times. The code must reference the form through the navigation form. Somehow the navigation form name must be included. However, I have yet to figure out the correct syntax for other posters with this issue. I don't use navigation form nor macros.

    Google: macro reference subform on navigation form
    Maybe you will be successful.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Stop Macro on Last Record in Form
    By wdkoseck in forum Access
    Replies: 1
    Last Post: 12-04-2012, 02:25 PM
  2. Record Storage DB Relationship Help
    By MintChipMadness in forum Database Design
    Replies: 12
    Last Post: 08-02-2012, 02:56 PM
  3. Replies: 7
    Last Post: 05-01-2012, 11:43 AM
  4. Updating a record with a value through a macro
    By jlgray0127 in forum Programming
    Replies: 1
    Last Post: 10-06-2011, 02:34 PM
  5. Macro on New Record
    By blue4512 in forum Access
    Replies: 13
    Last Post: 06-09-2011, 10:13 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums