Bookmark property

[Joef]

Hi all.
I,ve set asn array varRecord(intI) = rst.bookmark

How do i check whcih record I,m in. For example i can do
this.
rst.bookamrk = varRecord(inti).

But if i use an If(rst.bookmark = varRecord(IntI))then

I get an error. So how do i check to see what record I,m
in. I can't use a primary key as i have multiple records
with the same identifying feature. I can count how many
records of a certain "species" i have. But i need to know
which one i,m on. Lets say I have 5 Lions...I need to know
If i,m on Lion 1 or two etc. The bookmark was the only way
i could think of doing it but how do I check it as above?
thanx

 

[Jeremiah Ellison]

The recordset property AbsolutePosition will tell you what record number you're on. It's zero-based so it counts starting at
0.

Hi all.
I,ve set asn array varRecord(intI) = rst.bookmark

How do i check whcih record I,m in. For example i can do
this.
rst.bookamrk = varRecord(inti).

But if i use an If(rst.bookmark = varRecord(IntI))then

I get an error. So how do i check to see what record I,m
in. I can't use a primary key as i have multiple records
with the same identifying feature. I can count how many
records of a certain "species" i have. But i need to know
which one i,m on. Lets say I have 5 Lions...I need to know
If i,m on Lion 1 or two etc. The bookmark was the only way
i could think of doing it but how do I check it as above?
thanx

Jeremiah Ellison
Ellison Enterprises - Your One Stop IT Experts