Error Message - Problem occured communicating w/ OLE or ActiveX

  • Thread starter ScottMSP via AccessMonster.com
  • Start date
S

ScottMSP via AccessMonster.com

Hello,

Thank you for reading this post.

I have a form with a combo box (SvyName_ID) that looks up the field
SvyName_ID from tlkpSurveyNamesMaster and places the SvyName_ID into
tBenchmarkJobMatches.

From the same tlkpSurveyNamesMaster, I want to take another field
SvyEffectiveDate and put it in the same tBenchmarkJobMatches.

I put an Event Procedure (VBA) in the combo box SvyName_ID to auto fill to do
this, but I get an error message: "The expression After Update you entered as
the event property setting produced the following error: A problem occured
while Microsoft Office was communicating with the OLE server or ActiveX
Control."

Here is the VBA:
Private Sub SvyName_ID_AfterUpdate()
Me.SvyEffectiveDate = Me.SvyName_ID.Column(2)
End Sub

What am I doing wrong?

Thanks in advance.
 
S

ScottMSP via AccessMonster.com

Hello,

Just to clarify, I am working Access 2007 and was using a Split Form. When I
tried the code in a regular form, the After Update Event worked fine. Is
this a bug in Access 2007?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top