there are 3 forms and 1 table involved here. the first form (frmExpSnapShot) has a button to open the second form (frmViewNotes) and the second form has a button to open the third form (frmEnterNotes). the table (tblNotes) contains the notes and has a autonumber ID for each different note entry.
frmExpSnapShot contains expense report information and has a button that will open frmViewNotes for the user to view notes that correspond to that record(they are connected by an expense id). on frmViewNotes there is a button to open frmEnterNotes that will allow the user to enter new notes for that record.
when ever there is a new expense report with no notes and the frmViewNotes is opened and closed without adding any new notes a new record is still generated.
frmExpSnapShot contains expense report information and has a button that will open frmViewNotes for the user to view notes that correspond to that record(they are connected by an expense id). on frmViewNotes there is a button to open frmEnterNotes that will allow the user to enter new notes for that record.
when ever there is a new expense report with no notes and the frmViewNotes is opened and closed without adding any new notes a new record is still generated.