RECORD SOURCE PROPERTY LENGTH 1

[turns20]

Hello,

I am changing the recordsource on a subform programatically with various SQL statements. One of my particularly large SQL is not working and giving back the error 'the setting for this property is too long'. The length of the SQL statement is 2155 characters.

Does anybody know how to reset the length property on the recordsource or suggest an alternative solution.

Thanks for your time.

 

[PHV]

Use alias instead of full table name:
SELECT A.Field1, B.Field2
FROM [table 1] A INNER JOIN [table 2] B ON A.PKey=B.FKey
WHERE A.SomeField=SomeCondition

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[turns20]

Thanks, great tip, should've thought of it myself!
kt