>Fred,
>
>A form method? Can you explain a little more?
>
>>Just to point out that .RowSourceType=3 does not require a SQL statement. I usually have mine pointing to a form method that does the SQL, rather than trying to cram it into the property sheet.
>>
Just create a custom form method (Form menu, new method). Now if in your .RowSourceType=3, in your .RowSource property you put "thisform.MethodName()" and as long as your method returns a cursor or table and is the current work area, your ListBox/Grid/ComboBox/etc gets populated. No trying to cram a complex SQL statement into the property sheet.