Error Message - Problem occured communicating w/ OLE or ActiveX

[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.

 

[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?