Results 1 to 2 of 2
  1. #1
    mlrucci is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2018
    Posts
    202

    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 offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    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....
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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