You can always combine parts of the expression and execute the new string like this:
str1 = "Select * "
Str2 = " From my_table "
Str3 = " where this = lcThat "
MySTR = Str1 + str2 + str3
&MyStr
I have been doing this since FPD.
__Stephen
>>Well, you can use a UNION clause in your SELECT. Your SELECT can be as complex as you like - I don't know if there's a limit on the length... maybe 256 characters?
>
>Haven't thought about the limit. You're right, we can not put more than 255 chars in a property sheet.
>
>Anyway, all this research I made not for my application, but for my colleague's. So, I know the solution now and may suggest it.
>
>
>>>Hi everybody,
>>>
>>>We have towns combobox, which has ControlSource BldMstr.town and RecordSource select town, fullname from towns
>>>
>>>Suppose, we have entries in a BldMstr table, which are not in Towns table. How can we show them in the combobox?
>>>
>>>Thanks in advance.