Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2011
    Posts
    35

    Unanswered: To few parameters, expected 1.

    Error says To few parameters, expected 1.

    But i don’t see where my syntax is wrong?

    Set rst = CurrentDb.OpenRecordset("SELECT [PROVIDER] FROM Master_Database WHERE [PROVIDER] = " & PROVIDER.Value & " ;")

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    What's the data type of PROVIDER? If it's text, try

    Set rst = CurrentDb.OpenRecordset("SELECT [PROVIDER] FROM Master_Database WHERE [PROVIDER] = '" & PROVIDER.Value & "' ;")
    Paul

  3. #3
    Join Date
    Dec 2011
    Posts
    35
    Thanks it worked!

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    No problemo!
    Paul

Posting Permissions

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