>>However, I solved the problem with changing RecordSourceType to 1-Alias instead of 0-Table. But I still don't understand why it doesn't work directly with table. There was also an index (ChildOrder) I used, perhaps I've done something wrong with it.
>
>I recall having trouble with Table as sourcetype a long time back, and have never used it since -- you'll be safe using Alias...
Even with SourceType = Alias I just ran into a funny problem. I was setting my column controlsource values in code, and if I used the field name
without the alias the columns were read only (no matter what the ReadOnly property said) and could not be updated. As soon as I added the alias
MyCursor.MyField they columns could be edited.
HTH
Barbara