I have a form called "frmEnterNewCust" which takes in details of new Customers to be added to a table called "tblCust".The record is saved after every entry into the form. There is a key field called CustID which holds a unique numeric identity value for each customer to base search criteria on.
What I want to do is generate a report with the details of the current record that has just been entered then to create a mailmerge feature to " MS Word " and then to close and save the ".doc" file once finished.
Please can you point me in the right direction on how to select only the last record entered into my form ,transfer the details to report, then finally closure within MSWord.
---------
Marty..
What I want to do is generate a report with the details of the current record that has just been entered then to create a mailmerge feature to " MS Word " and then to close and save the ".doc" file once finished.
Please can you point me in the right direction on how to select only the last record entered into my form ,transfer the details to report, then finally closure within MSWord.
---------
Marty..
