Results 1 to 3 of 3
  1. #1
    reynier09 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2016
    Posts
    17

    Accessing controls from navigation form

    I have a main navigation form which name is MainUtas, one of his tabs or navigation buttons is NavigationButton9
    which Caption is Quality and opens the QualityNav form (which I think becomes a subform). In QualityNav I have
    more navigation buttons, one is NavigationButton7 which caption is Training Records and opens the RecordsTraining form,
    where I have Text5 (a textbox). In RecordsTraining I have an unbound ComboBox (Combo2) from where Text5 control
    source is: =[Combo2][Column](3). I also have a button that opens a report, which source is a query based on the value
    of Text5. My issue is: when I had the RecordsTraining form by itself everything ran fine, but now I'm getting the enter the
    parameter pop-up when accessing it within the navigation form. I tried following the path on the builder but from the main
    navigation is not possible.I tried this also but didn't work: [Forms]![MainUtas]![QualityNav].[Form]![RecordsTraining].[Form]![Text5].


    Any help will be appreciated it. Thanks

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,969
    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.

  3. #3
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,826
    NavigationButton9 which Caption is Quality and opens the QualityNav form... In QualityNav I have more navigation buttons...
    You have a form on a navigation form, and the form contains another navigation form? Hope not - that would be masochistic.

    I thought the syntax was Forms!NavigationForm!NavigationSubform.Form.YourCo ntrolName, but only works for the top level form. Only one form can be loaded into a nav form at one time, so if you're planning to pass values from one to another, you won't be able to do it directly. You'll need temporary variables. I'm with June7 - I can't create them, but probably wouldn't if i could (except to play around). Seems to me they add an unnecessary level of complexity for little gain.
    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: 5
    Last Post: 04-01-2016, 09:54 AM
  2. Replies: 1
    Last Post: 08-14-2015, 12:01 PM
  3. Replies: 6
    Last Post: 06-07-2014, 04:42 AM
  4. Replies: 5
    Last Post: 08-08-2013, 06:20 PM
  5. Accessing form controls
    By dante in forum Forms
    Replies: 15
    Last Post: 07-28-2009, 08:26 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