wrong record is displayed

S

SandyR

I have a form which will be instantiated more than once. In the first
instance I want to open it to the last record of the table. In subsequent
instances, I want to pass the record number to open as a parameter. I am
having trouble with the first instance (I haven't even tried subsequent ones
yet). The form opens to the first record, even though it correctly sets a
book mark to the last one.

Here is my code:
The Switchboard Form runs this procedure:
 
R

richard harris

hi, have you tried basing the form on a query of the table and then setting
the autonumber to sort descending.

regards

richard
 
Top