If it get's more complex than that, you can just create the cursor elsewhere, and just use the cursor as the recordsouce for the combobox. You can build it in the form's INIT, or from another control's method.
>>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.
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site