Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2007
    Posts
    81

    Unanswered: Always coming MSG "Enter Parameter Value"

    Hi Dears

    I paste 3 Sub form into a form, 3 sub forms in different quiries and different table.

    when I open a form or make inquiry by any one of sub form I get Box MSG " Enter Parameter Value".

    thank you

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,468
    Provided Answers: 10
    one of of quiries is looking for a feild that does not exist
    hope this help

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

  3. #3
    Join Date
    Apr 2007
    Posts
    81
    Hi myle

    I check all quiries running OK.

  4. #4
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Your error message should also have a field name in it.

    Enter Parameter Value
    SomeField

    That's the field in your query that it doesn't like for some reason.
    Inspiration Through Fermentation

  5. #5
    Join Date
    Apr 2007
    Posts
    81
    Hi myle

    Msg box coming for inquiry as Indirect inquiry so I need direct through the sub form.

  6. #6
    Join Date
    Sep 2006
    Posts
    265
    I think this is a case of declaring the variable in your Criteria as:

    & '" Forms![MyForm]![Whatever] & "'

    Forgive my vagueness as I had this problem along time ago and re-wrote the Query using VB and I never resolved using Parameters. My VB statement looks like:

    intSQLWhere = intSQLWhere & " AND ClientsQuery.[Country Region Ref] = '" & rs![Mail Criteria Region] & "'"

    Simon

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •