I have a table with almost 137000 records.

On my form I have 5 combo boxes where the record source type is "Fields"; {ccode, cname, id}, and the Record Source is the above table.

When loading the form the combo boxes take really long to appear (load). I suspect it is because of the size of the Record Source. The time hey take to load is not tolerable, but I do need it the boxes!

Is there a way to speed them up, or is there anything else I can use?

Thanks in advance!