R
rbm
have an Access97 form with a subform (subD1W) that displays a number of
values from a query. The query name is "qryD1W". The values are displayed as
a continuous form. When I change one of the values in the subform, I want to
determine the recordnumber (absoluteposition) of the value I just changed.
This will direct other functions.
I had it working in an Access2000 database, but when I converted it back to
Access97, it stopped. In Access2000, when I changed one of the values, the
value field AfterUpdate event worked correctly. It was simply:
lngPos = Me.Recordset.AbsolutePosition
If lngPos = ..... Then .... etc.
In Access97, the same code gets a "method or data member not found" error
message and highlights ".Recordset"
In the Access2000 database, I had not Dim'd the Recordset, but that seems to
be the stopper now.
Any help would be greatly appreciated.
values from a query. The query name is "qryD1W". The values are displayed as
a continuous form. When I change one of the values in the subform, I want to
determine the recordnumber (absoluteposition) of the value I just changed.
This will direct other functions.
I had it working in an Access2000 database, but when I converted it back to
Access97, it stopped. In Access2000, when I changed one of the values, the
value field AfterUpdate event worked correctly. It was simply:
lngPos = Me.Recordset.AbsolutePosition
If lngPos = ..... Then .... etc.
In Access97, the same code gets a "method or data member not found" error
message and highlights ".Recordset"
In the Access2000 database, I had not Dim'd the Recordset, but that seems to
be the stopper now.
Any help would be greatly appreciated.