I am opening a rs from a 800 record table using an SQL and putting three fields into a combo box. When I have one field, life is good, when I have more than one field, I get the error as noted in the subject line. Are there limits to the number of fields or characters in a combo?

---

Reply from Richard Rost:

I've had combo boxes with LOTS of records, but it sounds to me like you're MANUALLY adding records to the combo box itself instead of setting up the ControlSource so that it uses an SQL statement. If you try to add the data directly into the combo box, you won't be able to have more than a few dozen items until you run into this problem.

Your combo box should use a TABLE, QUERY, or SQL STATEMENT as a ControlSource. Don't use a static list of values unless it's REAL small (like shipping methods, for example).