filtering combo box with checkbox

C

Chris

OK here goes. I have a combo box which is attached to the rowsource
TblApplicant. This table has 2 values 1) First Applicant, 2) Second
Applicant. The control Source is in tblClients and is called applicant. On
my form I have a chkBox named chkJoint and a cboBox called cboApplicant.
When the chkJoint = -1, I want the cboApplicant to display First Applicant
and Second Applicant. The user will then select either first applicant or
second applicant. However, if the chkJoint is = 0 ( it is not a joint
mortgage and therefore shall only have one applicant meaning that I do not
want to have the option for second applicant - just the first applicant)
Then I would like First applicant to be displayed and the option for second
applicnt to be hidden

If chkjoint.value = 0 THEN
cboApplicant = First Applicant
Else
cboApplicant = First Applicant, Second Applicant
End If

cheers all
 
Top