Results 1 to 3 of 3
  1. #1
    Newby is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Posts
    60

    Enter Parameter Value

    I am try to execute a query based on criteria from a form combo boxes. I select a date range, expense type and business or personal with no problem. When I add a source combo box to my query criteria, I get Enter Parameter Value. I do not know why this criteria is treated differently.



    These work good
    Like IIf([Forms].[SourcesSelect].[Cbx_RentalPersonal]="All","*",[Forms].[SourcesSelect].[Cbx_RentalPersonal])
    Like IIf([Forms].[SourcesSelect].[Cbx_IncExp]="All",'*',[Forms].[SourcesSelect].[Cbx_IncExp])
    <=[Forms].[SourcesSelect].[Cbx_YYYY_MM_End] And >=[Forms].[SourcesSelect].[Cbx_YYYY_MM_Beg]

    Not good; Enter Parameter Value
    [Forms].[SourceSelect].[Cbx_Source]

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    You have

    [SourcesSelect] and [SourceSelect] ??? Seems like a spelling error.

  3. #3
    Newby is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Posts
    60
    Never mind. I am a moron.

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

Similar Threads

  1. Enter parameter value
    By sperriss in forum Access
    Replies: 8
    Last Post: 07-01-2014, 10:27 AM
  2. Enter Parameter Value
    By Everdale in forum Forms
    Replies: 5
    Last Post: 09-09-2013, 07:59 AM
  3. Enter Parameter Value?
    By IzzyKap in forum Forms
    Replies: 3
    Last Post: 12-21-2012, 08:43 AM
  4. Replies: 13
    Last Post: 01-10-2012, 09:56 AM
  5. Enter Parameter Value
    By gutes2 in forum Forms
    Replies: 3
    Last Post: 03-03-2010, 05:03 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