Required field dependent on another field...
I am trying to make a form field required only if a selection is made on a separate combo box. i.e. A form collects data for insurance quotations. Each record (quotation entered on form) can hold up to 5 coverages (life, disability, medical, accident or pension). If you, for example, choose "Life" for coverage 1, I want the status (pending, sold or lost) field to become required.
I wrote the following code, which incidentally does not work. Can anyone point me in the right direction? I also put this code in the BeforeUpdate event; is this correct?
________
Dim type1 As Field
Dim status1 As Field
type1 = tblQuoteLookup.cboCover1
status1 = tblQuoteLookup.cboCover1Status
If Not IsNull(type1) Then
status1.Required
End If
________
Many thanks,
Nick
|