Results 1 to 2 of 2
  1. #1
    offie is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013
    Posts
    176

    Navigation Form Problems

    I put the form OverallSearch into a Navigation Form.

    The OverallSearch form contains one unbound text box to search through queries, with 3 subforms with the query results.

    I went into all the queries and added [Navigation Form]! beofre [OveralSearch]...etc in the criteria fiels that I am using

    When I open the navigation form and go to the OverallSearch tab I am prompted for parameter [Forms]![Navigation Form]![OverallSeach]!...etc multiple times



    So I went back and got rid of all the [Navigation Form]!'s from the queries and I was still promted for parameters.

    What is going on here?

    Note: Before the navigation form the OverallSearch worked perfectly when I opened it

    Thanks!
    Last edited by offie; 06-25-2013 at 10:44 AM.

  2. #2
    offie is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013
    Posts
    176
    So I figured that
    Forms![OverallSearch]![PorjectNumbertText]
    Had to become
    Like [Forms]![Navigation Form]![NavigationSubform].[Form]![ProjectNumberText]

    HOWEVER:

    Does anyone know who to refresh a subform withing a navigation subform?
    Edit:
    [Forms]![Navigation Form]![NavigationSubform]![SubFormName].Requery
    Last edited by offie; 06-25-2013 at 10:44 AM.

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

Similar Threads

  1. Replies: 3
    Last Post: 09-06-2012, 09:50 AM
  2. How to create a Search Form in a Navigation Form
    By RagonichaFulva in forum Forms
    Replies: 5
    Last Post: 08-21-2012, 01:28 AM
  3. Replies: 7
    Last Post: 11-16-2011, 01:22 PM
  4. Replies: 2
    Last Post: 08-18-2011, 10:20 PM
  5. How to reference a form in the Navigation Form
    By HarryScofs in forum Access
    Replies: 3
    Last Post: 08-18-2011, 04:46 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