Current Record in a SubForm

[GGleason]

Using VBA, is it possible to detect where the pointer (current record marker) is at (such as record 7) in a subform?

tia,
GGleason

 

[JoanneM]

Are you referring to a record id as being record 7 or the records actual position in the displayed dataset?

regards

jo

 

[GGleason]

Jo,

It would be the record's actual position in the displayed dataset.

Thanks,
GGleason

 

[JoanneM]

I have a distant recollection of a rowpos function so I am going to do a quick check on MSDN and make sure I am not getting my languages mixed and post it back

regards

Jo

 

[JoanneM]

Thought so

what you are after is the .absolutposition property of a records set

a quick way to do this is
on your subform pu an unbound txt box named txtPointer

dim rs as object
dim pntr as variant
set rs= me.recordsetclone
txtpointer = rs.absoluteposition + 1 ('absoluteposition is zero based )

This may go some way to helping you solve your problem

 

[GGleason]

I can't get this to work.

Is there a way to get that number that appears on the bottom of the form (that indicates the record number) into code?

Thanks

 

[JimConrad48188]

Dim x as Long

x = Me.Recordset.AbsolutePosition + 1

 

[GGleason]

Jim,

Can you tell me where this code is placed?

Thanks,
GGleason