TIP: Click on subject to list as thread! ANSI
echo: win_access
to: ALL
from: JEFF JOHNSON
date: 1996-08-04 00:31:00
subject: Switching records

   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)

SOURCE: echomail via exec-pc

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.