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