Hi all,
I know lots of people have had similar questions, but I've been unable to find a solution that works in my instance, so please be gentle!
I'm developing a database in Access 2016. I have a form called frmContacts, which contains contact info (plus a sub-table with a snapshot view of the opportunities generated from the contact being viewed). I wish to link all new Opportunities to the originating contact, so I want to be able to do the following:
- click a button in the Contact form
- open the Opportunities form
- make a new record in Opportunities, using the ContactID taken from the Contact form
I just require a single numerical value (ContactID) to be copied across.
Any assistance would be very gratefully received.
Best wishes,
Pete
I know lots of people have had similar questions, but I've been unable to find a solution that works in my instance, so please be gentle!
I'm developing a database in Access 2016. I have a form called frmContacts, which contains contact info (plus a sub-table with a snapshot view of the opportunities generated from the contact being viewed). I wish to link all new Opportunities to the originating contact, so I want to be able to do the following:
- click a button in the Contact form
- open the Opportunities form
- make a new record in Opportunities, using the ContactID taken from the Contact form
I just require a single numerical value (ContactID) to be copied across.
Any assistance would be very gratefully received.
Best wishes,
Pete