Hi All
I have a main form, frmOverview, which displays a list of current sites. On this form is a button which allows a user to enter a New Site with its Agreement. On this form, frmNewSite, is a drop down list of the current Clients. When the client is selected I need to be able to pass the Client ID into the current form, frmNewClient, and the Agreement form, frmNewAgreement and store it in the relevant tables associated with these forms, tblSites and tblAgreement.
I'm not that experienced so the more guidance the better.
Any help would be much apreciated.
ChrisD
I have a main form, frmOverview, which displays a list of current sites. On this form is a button which allows a user to enter a New Site with its Agreement. On this form, frmNewSite, is a drop down list of the current Clients. When the client is selected I need to be able to pass the Client ID into the current form, frmNewClient, and the Agreement form, frmNewAgreement and store it in the relevant tables associated with these forms, tblSites and tblAgreement.
I'm not that experienced so the more guidance the better.
Any help would be much apreciated.
ChrisD
