syntax help

Discussion in 'MS Access' started by needhelp, Mar 17, 2007.

  1. needhelp

    needhelp New Member

    Mar 17, 2007
    Likes Received:
    Trophy Points:

    I'm not sure if this will be enough information to help me, but here goes....

    I get a runtime error from the statement below that says "No value given for one or more required parameters" . Can anyone figure out why?? I'm stuck.......thanks!

    .Source = "select timage.*, InStr([Keywords],'" & [Forms]![search options]![searchtext] & "') AS Expr1, IIf(IsNull([forms]![search options]![combo121]),[category],[category]=[forms]![search options]![combo121]) AS Expr2" _
    & " FROM timage WHERE (((InStr([Keywords],'" & [Forms]![search options]![searchtext] & "'))>0) AND ((IIf(IsNull([forms]![search options]![combo121]),[category],[category]=[forms]![search options]![combo121]))=-1));"

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice