Results 1 to 2 of 2
  1. #1
    mlrucci is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2018
    Posts
    91

    go to record from list

    Good afternoon, I have a form with a subform attached. I have built a list that has all the client's names. I am attempting to click on the list to go to record with same ID in the list. I am working with a navigation form, so I do not want to open another form I would like to go to record. Can anyone help?

  2. #2
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    8,604
    You have a subform on a form and that form is on a built in navigation form?

    Try
    Code:
    [Forms]![Navigation Form]![NavigationSubform].Form.NameOfYourSubformContainerControl.Form.NameOfControlThatContainsTheID
    to get the record ID, then use that in the GoTo method. There might be a shortcut to the control on a subform on a form on a nav form, but I don't use navigation forms, so....
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    Iím telling everyone it's good to eat dried grapes. Itís all about raisin awareness.

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

Similar Threads

  1. Replies: 8
    Last Post: 12-13-2017, 10:38 AM
  2. Replies: 8
    Last Post: 02-04-2016, 05:10 PM
  3. Replies: 4
    Last Post: 07-03-2013, 10:02 AM
  4. Replies: 3
    Last Post: 08-26-2012, 10:04 PM
  5. Replies: 9
    Last Post: 09-16-2011, 03:52 PM

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 - Senior Forums