Pete,
If the rowsourcetype of the combo is Fields the rowsource must be Alias.Field1,Field2,Field3. Note that the alias is ONLY on the first field name and not the others. The message you are getting is exactly the message that this syntax error will evoke.