koolwaters
Active Member
- Joined
- May 16, 2007
- Messages
- 403
I have a form which is capturing contact details for clients. We need to record 3 forms of identification for clients and so I have a separate table to capture the identification information.
The main form captures the contact information and the subform is used to capture the identification information for the contact. The subform is bound to the main form using the ContactID. The other fields on the subform are: IdentificationType(combo box which looks up the ID types from tblIdentificationType), IdentificatioNumber, Date Issued and Date of Expiry.
I have a save button on the form which is used to save the contact's record.
I have added code in the BeforeUpdate event of the subform to ensure that the ID Type, ID number and Date Issued are entered but that does not work when I click the Save button on the form and I am able to save and exit without entering identification information for the contact.
So before saving the record, I want to make sure that identification information has been entered on the subform.
If it is possible, I would also like to get some code to make sure that 3 identification records are captured for the contact.
Thanks for any assistance.
The main form captures the contact information and the subform is used to capture the identification information for the contact. The subform is bound to the main form using the ContactID. The other fields on the subform are: IdentificationType(combo box which looks up the ID types from tblIdentificationType), IdentificatioNumber, Date Issued and Date of Expiry.
I have a save button on the form which is used to save the contact's record.
I have added code in the BeforeUpdate event of the subform to ensure that the ID Type, ID number and Date Issued are entered but that does not work when I click the Save button on the form and I am able to save and exit without entering identification information for the contact.
So before saving the record, I want to make sure that identification information has been entered on the subform.
If it is possible, I would also like to get some code to make sure that 3 identification records are captured for the contact.
Thanks for any assistance.