Results 1 to 4 of 4
  1. #1
    lhanley22 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2021
    Posts
    7

    Enter Paramter Value Box

    I have a dB "waterfront drawing library", a query "searchquery", a form "reference drawing search", a subform "searchquery". "Reference Drawing Search" searches the database using the "searchquery" using the functions:
    Like "*" & [Forms]![Reference Drawing Search]![Jnametxt] & "*"
    (Jnametxt is a textbox on the "reference drawing form"). The query searches a few fields on "waterfront drawing library" using the same function structure above. The results of the query are shown on the "searchquery" subform on the "reference drawing search" form

    Upon building this search tool, It all worked great. But sometimes if I save and close and re open the file (every form, query is saved and closed separately too), I get the "Enter Parameter Value" box and I have to click through all of the query criteria until I can get to my forms or query. And then the subform does not work. If I go in and rewrite the query and recreate the subform on the main form I can get it to work again. Any idea why this is happening. Also related: I run a "requery" macro on my "reference drawing search" form. And when i'm having the issue explained above, the macro is also not working. I click it and get the: "the command or action Requery isn't available right now" error.



    Quite Frustrating. Any help would be appreciated

    Click image for larger version. 

Name:	exampleerror.jpg 
Views:	18 
Size:	9.2 KB 
ID:	45806

  2. #2
    Minty is online now VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    1,930
    That looks as if the form reference should have [ ] around it as it has spaces in it.

    9 out of 10 times this type of error is due to spelling errors/ typos.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    9,182
    Unless you open a form/report/query in design and alter it, there is nothing to save. Access automatically handles new or edited data in bound forms and editable queries in a few ways, none of which require you to click Save. I'm seeing the mentioned brackets [Forms]![Reference Drawing Search]![Jnametxt] and if this works sometimes and not others, it can't be a mis-spelled control name IMO. I wonder if you have name auto correct enabled in db options and at some point you changed the name of your control or form. The old name might be raising its ugly head behind the scenes. Suggest you compact/repair db and see what happens. The general consensus seems to be to turn off name auto correct.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    Iím telling everyone it's good to eat dried grapes. Itís all about raisin awareness.

  4. #4
    ssanfu is offline Master of Nothing
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,361
    Consider posting your dB for analysis.
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

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

Similar Threads

  1. ERROR in formula and Paramter Values
    By nwood in forum Queries
    Replies: 1
    Last Post: 04-27-2017, 10:46 AM
  2. Paramter & Form Problems
    By Korei Khan in forum Database Design
    Replies: 3
    Last Post: 10-24-2015, 10:44 AM
  3. Dynamic Date Paramter Change?
    By aellistechsupport in forum Queries
    Replies: 27
    Last Post: 08-27-2015, 01:21 PM
  4. Replies: 3
    Last Post: 03-05-2015, 04:15 PM
  5. Replies: 3
    Last Post: 10-22-2014, 02:38 AM

Tags for this Thread

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 - Senior Forums