1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

syntax help

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

  1. needhelp

    needhelp New Member

    Joined:
    Mar 17, 2007
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    Hi,

    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