Moving to a record in a bound form

[Chris Strug]

Hi,

Probably a silly question but I've realised that I don't actually know how
to do this properly: Basically what is the best way to navigate to a
particular record in a bound form if you know the PK of the record in
question and assuming that it exists.

In the past I have created a recordsetclone, used the findfirst method and
then set the bookmark of the bound recordset to that of the recordsetclone.
However I'm pretty sure that this isn't a terribly good way to achieve this.

Is there a "best practice" for doing this?

Any and all advice, links, abuse etc are gratefully received.

Many thanks

Chris.

 

[Klatuu]

You are doing it correctly

 

[Van T. Dinh]

Sounds fine to me.

I do the same except I set the Form's BookMark instead of the bound
Recordset's BookMark. This only proves that I am from the old school since
in A97 and earlier versions, the bound Recordset is not exposed and the
Form's BookMark is used instead.

 

[Chris Strug]

Sounds fine to me.

I do the same except I set the Form's BookMark instead of the bound
Recordset's BookMark. This only proves that I am from the old school
since in A97 and earlier versions, the bound Recordset is not exposed and
the Form's BookMark is used instead.

Well, far be it from me to argue. That way always struck me as a bit
cumbersome but I'm more used to working with unbound forms I suppose.

Anyway, thanks Van / Klatuu for clearing that up!

Thanks

Chris.