complicated question

T

twisted5

I have a form (form 1) based on a query that selects certain records for
review containing a record number and a date. It has a command button that
opens a second form that the person reviewing the record enters their
comments for their review which has another command button opening a third
form to send a notice based on their review. The boss wants the record number
(current record on form 1) to populate the record number field on the second
form when it opens as well as another field not included in the query (but is
in the table the query is pulling from). Also, he wants the third form's
record number and date field (current record of form 1) to populate when that
form opens. I cannot for the life of me figure out how to do this. Can
anybody tell me how or at least a better way to set this complicated mess up?
Thanks!
 
M

mscertified

When you open a form, you can pass an argument called 'openargs' and this can
be received by the opened form (in the 'open' event) by referring to
'openargs'. This is the way you can pass the record number along the series
of opened forms. You can pass whatever information you need in this argument.
Look in Access Help for details.

Dorian
 
K

Klatuu

Be aware there is really no such thing as a record number in Jet. Depending
on the sort order, the AbsolutePosition property will change.
AbsolutePosition will give you the record number based on the current sort
order and the number of records in the recordset. There is no real world
value in using record numbers.
The closest you can possibly get is if you have an AutoNumber field in the
record, it will always be unique, but not necessarily sequential.
 
Top