Menu
Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Access Newsgroups
Access Beginners
newbee needs help
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Ken Snell [MVP]" data-source="post: 1931246"><p>One parameter likely is Forms![frm clients].[au-fk client id]. Concatenate</p><p>its value into the SQL string (excerpt shown here)</p><p>"[Au-pk Client id] = " & Forms![frm clients]![au-fk client id]</p><p></p><p>The other parameter may be coming from the lack of a space after the word</p><p>"and" in your string:</p><p>strsql = "Select * From [CC PCS Authorized Units] Where " & _</p><p>"[Au-fk Proc id] = " & "'" & Me![au-fk proc id] & "' and " & _</p><p>"[Au-pk Client id] = " & Forms![frm clients]![au-fk client id]</p><p></p><p>If that isn't it, then check the spelling of the two field names in your</p><p>string.</p></blockquote><p></p>
[QUOTE="Ken Snell [MVP], post: 1931246"] One parameter likely is Forms![frm clients].[au-fk client id]. Concatenate its value into the SQL string (excerpt shown here) "[Au-pk Client id] = " & Forms![frm clients]![au-fk client id] The other parameter may be coming from the lack of a space after the word "and" in your string: strsql = "Select * From [CC PCS Authorized Units] Where " & _ "[Au-fk Proc id] = " & "'" & Me![au-fk proc id] & "' and " & _ "[Au-pk Client id] = " & Forms![frm clients]![au-fk client id] If that isn't it, then check the spelling of the two field names in your string. [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Access Newsgroups
Access Beginners
newbee needs help
Top
