I would like to be able to move to different records on a form by typing
in a code and having the form go to the record which contains that code. The
code is the primary key of the file. I can already do this by using an
unbound text box, doing a FindFirst on a recordset based on the form's
RecordsetClone during BeforeUpdate (or After), and then setting the form's
Bookmark to the Bookmark of the recordset. However, I want to skip the use of
the unbound text box and use a field bound directly to the code. The trick
is, I need to cancel the update of the current record before moving to the
new record, so that a record's code doesn't get changed. This must be done
in BeforeUpdate, and you can't move to another record in BeforeUpdate. Also,
if you cancel BeforeUpdate, AfterUpdate doesn't happen, so I can't put the
code to switch records there. Any suggestions, or is the first method my
only hope? I just don't like the extra code involved in transferring the
value from the unbound text box into the invisible bound control.
--- FMail/386 0.98
---------------
* Origin: (1:363/603.4)
|