Unable to invoke subroutine when event fires

[jerryk]

Hi,

I have an Access Form. On one of the fields in the AfterUpdate event is set
to [=setdirty]. In the form's code there is a the following subroutine:

Public Sub setdirty()
bIsDirty = true
End Sub

When I change the field it attempts to call the code but is unable. Instead
the following error message is generated:

"The expression After Update you entered as the event property produced the
following error: The object doesn't contain the Automation object
'setdirty'."

Any ideas what is wrong?

 

[Marshall Barton]

I have an Access Form. On one of the fields in the AfterUpdate event is set
to [=setdirty]. In the form's code there is a the following subroutine:

Public Sub setdirty()
bIsDirty = true
End Sub

When I change the field it attempts to call the code but is unable. Instead
the following error message is generated:

"The expression After Update you entered as the event property produced the
following error: The object doesn't contain the Automation object
'setdirty'."

If you are calling the procedure directly from a control's
event **property**, then the procedure must be a function
and you must include the parenthesis.

 

[jerryk]

That was it. Thanks!

I have an Access Form. On one of the fields in the AfterUpdate event is
set
to [=setdirty]. In the form's code there is a the following subroutine:

Public Sub setdirty()
bIsDirty = true
End Sub

When I change the field it attempts to call the code but is unable.
Instead
the following error message is generated:

"The expression After Update you entered as the event property produced
the
following error: The object doesn't contain the Automation object
'setdirty'."

If you are calling the procedure directly from a control's
event **property**, then the procedure must be a function
and you must include the parenthesis.