I have a VB6 program that uses several ADO Recordsets to connect to an Access database.
In one part of my program I have code for adding a new meeting (uses the meetingRst recordset).
When the new meeting is added I requery the meetingRst and populate a ListBox detailing all meetings. I then want the program to write an invitation letter in Word (details of this letter are then stored in another recordset - letterRst).
My code that writes and saves the letter requires the meetingRst to be at the appropriate record, how do I navigate to the record just added? (When the recordset is requeried it is ordered by MeetingDate DESC).
Can anyone offer any recordset navigation tips?