AfterUpdate Error

  • Thread starter Thread starter Tom Bock
  • Start date Start date
T

Tom Bock

I use a combo box in a datasheet that updates multiple columns (based on the
record).

The few lines of code in the AfterUpdate Event are:

Private Sub Application_AfterUpdate ()
Me.Category = Me.Application.Column(1)
End Sub


At this time, I get the following error: "Method or data member not found".


I have this already working in another database. I have copied the working
solution and simply renamed the fieldnames and table name. I updated all
caption, names, queries... still I get the error as described. Does anyone
know what I'm missing here?

Thanks,
Tom
 
Tom Bock said:
I use a combo box in a datasheet that updates multiple columns (based on the
record).

The few lines of code in the AfterUpdate Event are:

Private Sub Application_AfterUpdate ()
Me.Category = Me.Application.Column(1)
End Sub


At this time, I get the following error: "Method or data member not found".


I have this already working in another database. I have copied the working
solution and simply renamed the fieldnames and table name. I updated all
caption, names, queries... still I get the error as described. Does anyone
know what I'm missing here?
Click to expand...

I suspect your code is confused because you named your control
"Application" which is a pretty important object in Access. It likely is
looking for a column() in the built in Application object rather then
looking at your control.
 
Try renaming your combo (and the sub)
The name Application is a reservedname that in the case
would refer to the container application object (MS
Access).
 
Back
Top