John,
The fields must all come from only one table, and only the first one can have the table alias listed. For example
MyAlias.Field1,MyAlias.Field2
will cause the error
(and a wonderfully helpful error message it is isn't it?). Your value should be
MyAlias.Field1,Field2
>I'm getting this message when a listbox Refresh method is called by the form itself. I have a listbox with:
>
>1. rowsourcetype=fields
>2. list of field names in the rowsource property
>3. controlsource is set to name of the table