Dear Users,
I have an Operator form containing 2 check boxes and 3
textboxes with associated labels.
1) chkPersonnellTrained, if it is checked I want the
Date trained label and textbox to show, if the
checkbox is unchecked then the label and textbox
should remain hidden.
2) chkFormalContract, it is checked I want the intial
and final date of contract labels and textboxes to
show, the same for this box.
I want this to be valid for each record in the table,
as you navigate from record to record on the form.
I have put the following code in the load event of the
operator form:
If chkPersonnellTrained.Value = 1 Then
lblDateLastTrained.Visible = True
txtDateLastTrained.Enabled = True
ElseIf chkPersonnellTrained.Value = 0 Then
lblDateLastTrained.Visible = False
txtDateLastTrained.Enabled = False
End If
If chkIsContract.Value = 1 Then
lblInitialContractDate.Visible = True
txtInitialContractDate.Visible = True
lblFinalContractDate.Visible = True
txtFinalContractDate.Visible = True
ElseIf chkIsContract.Value = 0 Then
lblInitialContractDate.Visible = False
txtInitialContractDate.Visible = False
lblFinalContractDate.Visible = False
txtFinalContractDate.Visible = False
End If
End Sub
The labels and textboxes only appear and dissapear
when I check the box for each record in the form
manually, it does not happen automatically on startup
when a new record is being entered.
Any help on this will be much appreciated.
Thank you.
Irshad
__________________________________
Yahoo! Music Unlimited
Access over 1 million songs. Try it free.
http://music.yahoo.com/unlimited/
------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
