Wow! I didn't know this! This, to me, is a bug, not a feature. Anyway, thanks for helping to solve "one" of my problem (today). :)
>>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
>>
>>TIA.
>
>You'll get that error if you specify the alias for anything but the first field in the RowSource. It seems pretty strange, but the way you need to list the fields is to have the alias in front of the first field, but none of the others.
It's "my" world. You're just living in it.