unbound form with DAO recordset in Access 97

[Marcel K.]

Greetings - I have created a recordset (no type specified)
that uses the .absoluteposition to determine which record
user is on - then this .absoluteposition + 1 gets put into
text box indicating the record number. The problem I have
encountered is after saving a new record
the .absoluteposition property is no longer available. To
get around the problem I am having, I link the source
tables instead of having locally. Is there something that
linking forces a recordsettype to have that allows
the .absoluteposition proprety to always work , be
enabled, etc.

Thanks in advance for your reply.

Marcel K.

 

[TC]

Check out dbOpenTable versus dbOpenDynaset.

HTH,
TC

 

[Guest]

Ahhhh....Now I see, thanks for the input.

-----Original Message-----
Check out dbOpenTable versus dbOpenDynaset.

HTH,
TC





.