I have a form that has been working correctly for a million years; the form has six combo boxes which are each tied to a lookup table - they were created with the wizard.

(The form is part of a formset and is in private data session. Recently another form, which just displays data and does not open any tables was added to this formset. It also is in private data session I mention this because it is a change to the environmnt.)

Out of the blue the first combo box on the original form does not work. Clicking it yields nothing. I placed a button the form to display status at runtime and all the lookup tables except the one this box is based on are open.

I used the wizard to create another_ combo box based on the lookup table and it__ does not work at runtime on the form either. I have verified that the lookup table is present and combo boxes based on it in other forms in the system work correctly. The lookup table still does show in the form's data envirnoment...


Any ideas?


TIA
Chris