Adjust Bookmark Record For Free

The RecordsetClone property setting is a copy of the underlying query or table specified by the form's RecordSource property.You use the RecordsetClone property to navigate or operate on a form's records independent of the form itself.

Recordsets refer to the group of records or the results that the database query delivers. It is considered as a common concept among various platforms such as ActiveX Data Objects and Data Access Object.Snapshot-type Recordset: A snapshot-type recordset is a static copy of reports that one can use to generate reports.

The error also encountered when user bookmark a string that was not saved from previously reading Bookmark Property. While using MS Access to open a corrupted access database file. When user uses the bookmark property of recordset objects to bookmark invalid string, then also this particular error will get prompted.

A recordset Bookmark is a special marker that you place in your recordset so you can quickly return or refer to it at some later stage.

In this article A bookmark is a Variant type value that uniquely identifies a record in a Recordset object. You can also use a variant array of bookmarks with the Recordset Filter method to filter on a selected set of records.

You can go to a specific record in Access when you know which record you want to find. The Go to box lets you choose a particular record from a drop-down list and is usually added to forms. To navigate to a specific record, click the arrow to the right of the Go to box, and then select a record from the drop-down list.

Use the Bookmark property with forms to set a bookmark that uniquely identifies a particular record in the form's underlying table, query, or SQL statement. Read/write Variant.