I have an Access 2003 database that is used to record details of all of our members. Table 1 [tblMembers] is populated via a form. We also have another Table [tblCRM]to record various scheduled calls we make to our members. The tblCRM appears as a subform on the main form. Each call made to a member has a specific 'reason' (a field which is a drop-down option on the subform). Every member has a unique [MemberID] , which has a one-to-many relationship with the various calls that can be logged on the CRM database.
Whenever a new member joins, we are required to setup 4 'blank' calls for them - each call is for a different 'reason': 30 Day, 6 Month, Renewal and 18 Month.
What I would like to be able to do is setup a macro so that when a new member is added and their member ID number is entered, that 4 'blank' calls are automatically created for them on the subform/tblCRM.
The 4 calls should be populated with 30 Day, 6 Month, Renewal and 18 Month in the reason fields. Does anyone know how I could do this? I'm not the brightest with regards to VBA, but have been able to get by so
far :)
the structure of my setup is now as
follows:
tblMembers = Parent table
tblCRM = Child table
frmMembers = Parent form
frmCRM = Child subform
The [MemberID] field is the the linked field between them. A member can have many calls on tblCRM, with the calls on the tblCRM being allocated to the unique MemberID on the tblMembers.
Thank you very muchly :)