it turns out i could use conditional formatting on my form to solve this one (disable/enable field)! Thanks though!

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...

Hello , I am using MS Access 2003. I have two Tables called 'Members' and 'CRM Database', which are related via the same memberhsip number. Basically, the CRM Database records all marketing calls made to members.

I have created a form for Members, with a sub-form for the CRM Database. With the CRM Database Sub-form, it displays all of the calls made to the member. I have tried to implement some VB code so that when a user chooses...