Reading single record (1 Viewer)

[JPFred]

I am writing some code and need to do the following:


Call up a form by clicking on the proper button from a menu

I need to add this to Form_Load


1. Prompt user for search data
2. Use the entered data to find the record using the search data
3. Once found I will insert the record to a "journal" file to get a "before" image
4. Call up a form to edit the current record
5. Upon clicking on an "Update" button I will write another record to the journal file with the new changes creating an "after" image.


My idea is to run an sql insert statement with the before and after images filling a field on a record with a "B" for before and an "A" for after.


This process is used to track changes made while giving me the ability to recover the "before image.


Any input would be appreciated.


Thanks,


Doc

 

[theDBguy]

Hi Doc. What have you tried so far? Maybe we can start there.