Results 1 to 7 of 7
  1. #1
    crimedog is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2013
    Posts
    141

    Criteria from Form Error - Enter Parameter Box


    I have a Query
    One Criteria draws from
    Code:
    [Forms]![0Frm_RepID].[TxtRepid]
    - Which is populated on the Open 0Frm_RepID Form
    Enter Parameter Error box popping up with:Forms_A224FEA8E5304184BB5CE85D6003E849.TxtRep ID

    I have deleted the Criteria and retyped it etc... if I leave the criteria blank it runs

    Does this look familiar?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,515
    DONT use period for objects, use exclamations
    [Forms]![0Frm_RepID]![TxtRepid]

    and if it STILL persists, compact/repair.

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,387
    and perhaps not use a number for the first character of the table name - it can cause problems. Maybe not in this case but sometime, somewhere.....

  4. #4
    crimedog is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2013
    Posts
    141
    I used the ! I compacted - I deleted the Query and recreated it - I renamed the form - It is still doing it...
    ---------------------------------------------------------
    I have a Query
    One Criteria draws from Code:
    [Forms]![0Frm_RepID].[TxtRepid]
    - Which is populated on the Open 0Frm_RepID Form
    Enter Parameter Error box popping up with:Forms_A224FEA8E5304184BB5CE85D6003E849.TxtRep ID

    I have deleted the Criteria and retyped it etc... if I leave the criteria blank it runs

    Does this look familiar?

  5. #5
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,387
    Does this look familiar?
    yes - looks like your first post on this thread. But doesn't look like you have dropped the initial 0 from your form name or changed the . for a !. and perhaps looking for the wrong thing?

    [Forms]![0Frm_RepID].[TxtRepid]

    Forms_A224FEA8E5304184BB5CE85D6003E849.TxtRep ID

  6. #6
    crimedog is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2013
    Posts
    141
    Sorry - that was from the first post - I just copied in for reference...

    I made the changes
    [Forms]![Frm_RepID]![TxtRepid]

    I even completely deleted the Query and started from Scratch -
    I printed out the Database Tools - DOcumenter for the Query
    The SQl had F[Forms]![Frm_RepID]![TxtRepid]

    The "Query Parameters" Section had

    Forms_A224FEA8E5304184BB5CE85D6003E849.TxtRepID

    If I am in Design view and choose "Parameters" in the menu - it does not show any

  7. #7
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,387
    suggest you copy and paste the whole sql to the query - go to the sql window in the query designer, not the documenter.

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

Similar Threads

  1. Enter Parameter Value error handling
    By PeakH in forum Access
    Replies: 5
    Last Post: 06-27-2017, 12:25 PM
  2. Enter Parameter Value Error
    By wojosh6 in forum Access
    Replies: 2
    Last Post: 12-15-2015, 09:56 AM
  3. Report 'Enter Parameter Value' Error
    By ndehhh in forum Programming
    Replies: 6
    Last Post: 10-18-2015, 05:18 PM
  4. Enter Parameter Value error
    By bronson_mech in forum Queries
    Replies: 9
    Last Post: 11-30-2013, 05:00 PM
  5. Enter Parameter Value Error in Macro
    By kasimagj in forum Programming
    Replies: 3
    Last Post: 09-19-2011, 03:53 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