Page 5 of 5 FirstFirst 12345
Results 61 to 64 of 64
  1. #61
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Navigation Controls are new to Access 2010 and I suspect this is simply a bug that will eventually be corrected by Microsoft. If this were just a SubForm displayed using the old method, I suspect it would work as you would expect.

  2. #62
    Join Date
    Jan 2013
    Posts
    6
    Bob Fin and Rural guy

    Your code worked for my applications.

    I modified it to fit mine - so, this is just a thanks. The data base is my Health and Safety Databse and the interlinked forms are Accident Register and Investigation Register. I needed the accident link feild on the investigation register to auto-populate.

    Private Sub Open_Invst_Click()
    DoCmd.OpenForm "Investigation Register", acNormal, "", acAdd, acNormal
    Forms![Investigation Register]![Accident Link] = Me.[ID]
    Exit_Command149_Click:
    Exit Sub
    End Sub

  3. #63
    Join Date
    Jan 2013
    Posts
    6
    So, I wouldn't mind now if you could help me re-write the investigation number back into the accident register - ????

    cheers.

  4. #64
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Is the "Accident Register" form open at this time? If so, you can go through the Forms collection as youn have done with Me.[ID] to the "Investigation Register" form.

Page 5 of 5 FirstFirst 12345
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Auto-populate form question: again!
    By revnice in forum Access
    Replies: 5
    Last Post: 08-06-2010, 04:02 PM
  2. Auto-populate form question
    By revnice in forum Access
    Replies: 19
    Last Post: 08-06-2010, 01:01 PM
  3. Replies: 3
    Last Post: 10-05-2009, 07:22 AM
  4. Auto Populate Data from Main Form
    By billiejean in forum Forms
    Replies: 0
    Last Post: 08-05-2009, 08:08 AM
  5. Auto populate fields on a form
    By ldarley in forum Forms
    Replies: 0
    Last Post: 08-14-2008, 09:39 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