Results 1 to 3 of 3
  1. #1
    AndycompanyZ is offline Advanced Beginner
    Windows Vista Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    80

    Navigation Form control syntax 2010

    I have a load of forms that now have been put into navigation forms using Access 2010 wizard. I know have found that most of the controls such as cascading comboboxes don't work and other comboboxes ask me for the parameter values when I open the form. I am unsure of the syntax for referning to these as I know the navigation forms are subforms and sonme of the comboboxes are in subforms themselves. I have as an example a combobox (cmboDepartmentID) that is asking me for the parameters whenever I open the formEvent ( through the navigation menu) this then has an unbound combox (cmboSubteamSF) on a subform (SubFormSubTeam). I have tried to work out the new reference but it isn't working so far I have as requery on the cmboDepartmentID:
    Forms!frmMainNavigation!NavigationSubForm!Form!Sub formSubTeam.Form!cmboSubTeamSF.Requery but this doesn't requery and the combobox is blank. Can anyone point me in the right direction please.

  2. #2
    AndycompanyZ is offline Advanced Beginner
    Windows Vista Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    80
    Also the query for the subteam combobox will need changing I imagine as it is now:
    SELECT tblSubTeam.SubTeam, ID
    FROM tblSubTeam
    WHERE (((tblSubTeam.DepartmentID) = [Forms]![frmEvent]![cmboDepartmentID]));
    and that isn't referencing the right form either.

  3. #3
    AndycompanyZ is offline Advanced Beginner
    Windows Vista Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    80
    Solved the answer was:
    [Forms]![frmMainNavigation]![NavigationSubform].[Form]![SubformSubTeam].[Form]![cmboSubTeamSF].Requery and i had to change the query to reflect the new reference too:
    SELECT tblSubTeam.SubTeam, tblSubTeam.ID
    FROM tblSubTeam
    WHERE (((tblSubTeam.DepartmentID)=[Forms]![frmMainNavigation]![NavigationSubform].[Form]![cmboDepartmentID]));

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

Similar Threads

  1. Replies: 2
    Last Post: 01-15-2011, 10:56 AM
  2. Banish the Access 2010 Navigation Pane
    By SteveF in forum Access
    Replies: 3
    Last Post: 12-07-2010, 10:44 AM
  3. syntax on setting image Picture control
    By cowboy in forum Reports
    Replies: 2
    Last Post: 02-18-2010, 10:00 AM
  4. Control Navigation Bar
    By Patrick.Grant01 in forum Access
    Replies: 0
    Last Post: 05-17-2009, 06:16 AM
  5. Control navigation pane
    By ohporter in forum Access
    Replies: 0
    Last Post: 05-27-2008, 12:45 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