This is error is normally due the the fact the the Rowsourcetype of the combobox (or listbox) is set to 6 (Fields) and the rowsource contains more then one field and is written in this format : myTable.field1,myTable.Field2
It is not required to use the table name at the second field (or any other fields after). It should read: myTable.field1,Field2
In addition here is a quote from Barbara Peisch
Actually, there's a bit more to it than what's in that FAQ, although the situation Mike points out is the problem 90% of the time. I've found you can get the "Field 'phrase' not found" error if there's any inconsistency in the RowSource, including if you have the wrong kind of RowSource specified for the RowSourceType. For example, if you pick a RowSourceType of "Array", but you have a SQL Select statment in the RowSource, you'll get that error. You'll also get that error with "Fields" if there's any typo in the RowSource.