Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to handle the error "field" phrase is not found in comboboxes

Tips -N- Tricks

How to handle the error "field" phrase is not found in comboboxes

by  Mike Gagnon  Posted    (Edited  )
[ol][li]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[/li]
[li]In addition here is a quote from Barbara Peisch
[quote BPeisch]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. [/quote][/li][/ol]

Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top