CurrentRecord property in a query?

judgehopkins

Registered User.
Local time
Today, 08:28
Joined
May 29, 2003
Messages
13
How do I get the CurrentRecord property into a query?
 
I know of no "Current Record" property, but I'm a neophyte.

If you're wanting to find the current record associated with a form, use a unique index associated with the record.
 
The value specified by CurrentRecord corresponds to the value shown in the record number box found in the lower-left corner of the form.

A primary key is, for example, an AutoNumber, a field data type that automatically stores a unique number for each record as it's added to a table.

Once a record is deleted, its primary key is gone also. A CurrentRecord number, however, might change.

If John Doe's CurrentRecord is 38, for example, if you delete records entered before his, the CurrentRecord will change; the primary key that was associated with the deleted records is gone forever.
 

Users who are viewing this thread

Back
Top Bottom