New to Access 2000 have a question
[355 byte] By [Nashmage] at [2007-11-11 6:53:09] 
I have been working with access 2000 for a little while and something that i need to do and cant think of how is that i have some fields that i am using with a checkbox/yes_no input and i want to make other fields but i want them to only show up if the checkbox is checked/yes is inputted. I would really appreciate it if someone could help me out thanks.
# 1 Re: New to Access 2000 have a question
you could check the value of the checkbox in it's click eventPrivate Sub chkYesNo_Click()
'example for a textbox
txtField.Visible = chkYesNo.Value
End Sub
if you have multiple fields that need to showed/hidden based on the value of the checkbox, make it an array then loop through it.
for i = 0 to txtFields.count - 1
txtFields(i).Visible = chkYesNo.Value
next i
does this help?
kulelat at 2007-11-11 23:48:00 >
