SQL and Bookmarks

[Gord]

Is it possible to extract the bookmark using an SQL query?

I'm using A2007 and have a select query used as the recordsource for a
subform. The query pulls out those records that match whatever date I
compare to. When the date criteria matches, I'd like to store a copy of the
bookmark from the underlying table as well.

Thanks,

Gord

[Wayne Gillespie]

On Mon, 10 Nov 2008 01:27:01 GMT, "Gord" <x1******@telus.netwrote:

>Is it possible to extract the bookmark using an SQL query?

I'm using A2007 and have a select query used as the recordsource for a
subform. The query pulls out those records that match whatever date I
compare to. When the date criteria matches, I'd like to store a copy of the
bookmark from the underlying table as well.

Thanks,

Gord

Why do you want to store the bookmark?

Bookmarks are volatile and are recreated (changed) every time the recordset is
opened or requeried so there is generally no use in storing them.

Do you have a specific need?

Wayne Gillespie
Gosford NSW Australia