Results 1 to 6 of 6
  1. #1
    rooflesh is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2012
    Posts
    3

    "Enter Parameter Value" for in Access 2010


    I have a sales database w/ different forms, subforms & queries that worked perfectly in Access 2007. When trying to open it in Access 2010, when opening the main form I am greeted with "Enter Parameter Value" for a query that is in a subform.
    Some criteria of the subquery is =Forms!MainForm!yearcombo so that the year selected from a combobox on the main form is reflected in the query.

    Was there a major shift in how this logic is supposed to work in 2010?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I'm not sure why it worked before but AFAIK SubForms have *always* loaded before the MainForm.

  3. #3
    rooflesh is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2012
    Posts
    3
    If I open the main form with the combo box & select a value, then open the query separately it will still say Enter Parameter Value for the combo box

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Try *importing* everything into a fresh, new db and see if the problem follows. http://www.btabdevelopment.com/ts/impnew

  5. #5
    rooflesh is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2012
    Posts
    3
    That was it man, you got it! Thank you so much it is truly appreciated!!

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You are very welcome.

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

Similar Threads

  1. Replies: 1
    Last Post: 08-02-2011, 07:21 AM
  2. Replies: 7
    Last Post: 01-23-2011, 12:32 PM
  3. Replies: 4
    Last Post: 01-06-2011, 10:52 AM
  4. location of "enter parameter value" box
    By dcjohnso11 in forum Programming
    Replies: 1
    Last Post: 06-25-2010, 11:36 AM
  5. Replies: 0
    Last Post: 03-25-2009, 05: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