Hi,
I have a form[frmTransactions] which is used for financial purposes. Within the[frmTransactions] I have several sub forms [sfrmTransport],[sfrmOfficeSupplies], etc.
The sub formsare hidden until the specific category is entered in the [frmTransactions] afterwhich the corresponding sub form is displayed, and the details of the gross amountare broken down into constituent parts.
Within thesub form as well as its own ID (Primary Key) there is a field to enter the ID(Primary Key) of the [frmTransactions].
My questionis, is there a way to automatically enter the ID of the open [frmTransactions]into the appropriate field in the open sub form?