But how does a method return a cursor? Does it return the name of the cursor?
>>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.
Steve Gibson