Not in List event problem (ActiveX)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

scubadiver - 18 May 2007 10:26 GMT

Still have a problem that I can't solve.

In my form I have two subforms and each subform has a single combo box with
a not in list event code. The problem is that one lets me enter new
information
and the other does not. I get the following message:

"A problem occured while Microsoft Access was communicating with the OLE
server or ActiveX Control"

If it is happening to one, why not the other as well?

I have compiled and compacted.

Reply to this Message

ruralguy - 18 May 2007 14:16 GMT

Try creating another ComboBox on the form and delete the one giving you
problems.

>Still have a problem that I can't solve.
>
[quoted text clipped - 9 lines]
>
>I have compiled and compacted.

Signature

HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Reply to this Message

scubadiver - 18 May 2007 15:24 GMT

I deleted the subform and started again. I've now got it working. Seems like
such a strange solution.

> Try creating another ComboBox on the form and delete the one giving you
> problems.
[quoted text clipped - 12 lines]
> >
> >I have compiled and compacted.

Reply to this Message

ruralguy - 18 May 2007 15:40 GMT

It is what can happen if you do not Compact and Repair regularly. There are
also some issues when you have Tools>Options>Name AutoCorrect turned On. It
should be disabled.
Failures caused by Name AutoCorrect: http://allenbrowne.com/bug-03.html

>I deleted the subform and started again. I've now got it working. Seems like
>such a strange solution.
[quoted text clipped - 4 lines]
>> >
>> >I have compiled and compacted.

Signature

HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Reply to this Message