Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2006
    Posts
    7

    Navigation Code

    I have a form with 1 subform. When I complete entering data on the form I goto the subform automatically. When I complete entering data on the subform I can click the navigation button for the next record and my subform and form are saved and I'm moved to the first record in the main form.



    I would like to examine the code behind the navigation button that does this, so I can add a command button that does the same thing.

    Is there a way to examine this code? Please Help!

  2. #2
    Join Date
    Nov 2006
    Location
    Arlington Heights, IL
    Posts
    7
    If you add a button to a form using the Command Button Wizard and select the "Record Navigation" option. From here you choices of "Find Next", "Find Record" and "Go to First, Last, Next & Previous." Once you make the selection and add the button you can go into Properties/Events and view the code under the "Event Procedure." This may help. There is also a "GoTo Record" command you could look up in help.

    Thanks,
    ScottG

  3. #3
    Join Date
    Oct 2006
    Posts
    7

    No Luck

    Quote Originally Posted by ScottG
    If you add a button to a form using the Command Button Wizard and select the "Record Navigation" option. From here you choices of "Find Next", "Find Record" and "Go to First, Last, Next & Previous." Once you make the selection and add the button you can go into Properties/Events and view the code under the "Event Procedure." This may help. There is also a "GoTo Record" command you could look up in help.

    Thanks,
    ScottG
    The command button has to be on the parent form for this to work and I can't get the focus back to the parent. I've tried putting the command button on the subform, but that doesn't work either.

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

Similar Threads

  1. Code Trouble?
    By briancb2004 in forum Access
    Replies: 0
    Last Post: 10-08-2008, 04:47 PM
  2. Need help with code
    By hoenheim in forum Programming
    Replies: 9
    Last Post: 09-11-2008, 04:19 PM
  3. Control navigation pane
    By ohporter in forum Access
    Replies: 0
    Last Post: 05-27-2008, 12:45 PM
  4. Need Help Getting to Code
    By Snuffles in forum Programming
    Replies: 8
    Last Post: 04-22-2008, 05:25 PM
  5. Problem with Code
    By cujee75 in forum Programming
    Replies: 0
    Last Post: 03-10-2006, 02:40 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