Hi,
I have combo box on a form for which I want to allow multiple item selection. I have set the Allow Multiple Values property = Yes for that field in the table design. When you click the combo box on the form, it appears as a list with check boxes and OK/Cancel. When I select one or multiple items and click OK, I get an error, "Object invalid or no longer set".
I only get this error for a field that allows multiple values - if I change the Control Source in the same combo box to a field where Allow Multiple Values = No, it works fine.
I do not get the error when entering directly in the table.
If I add a new combo box and set the control source to the same field, the same thing happens. If I add a new field to the table and set to Allow Multiple Values, the same thing happens.
I have another form and table in the same database that does not have this problem. I've tried to make sure all properties in both the table design and form design are the same.
Microsoft's online help says this:
You are attempting to reference an object that is no longer valid or has not been set.
Possible causes:
- The object has been closed.
- The object has been orphaned (the parent object has been closed or deleted).
- The object is out of scope.
- The object library is not registered in the Microsoft Windows Registry.
- You are trying to reference a method or property of the collection, but you have not assigned it to a variable first.
Any ideas?
Thanks,
Pete