Determine AbsolutePosition in Access97 subform

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

rbm

Sorry - it didn't look like it was posting. Please disregard and forgive me
for the duplicate posts.
 

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