Return to Next Record On Datasheet
Posted on 2013-09-17
I have a form containing a datasheet sub form used for processing records. When the user double-clicks on a record, it loads the corresponding customer form. Once processing has been completed, the underlying record from the datasheet is deleted and the sub form is refreshed. However, once refreshed, the pointer goes to the first record. I want it to go to the record just after the one just processed.
There are two triggers that cause the record in the datasheet to be deleted. If certain values are entered in the customer record, it deletes the record in the datasheet upon closing the customer form. The other method is clicking a 'Processed' button on the form containing the datasheet.
So, I need to add code in both locations or at the point that the form regains focus. Can someone help me with the VB code to accomplish this?