I am very new to VB and i am trying to learn more and more so that i can get better control of my databases. Hopefully someone can help me with this problem.
I have a form that allows music albums and tracks to be stored along with their location etc. On the form the first control is a combo box which looks up a value from another table in this case it is the music category i.e. album, r & B, compilation etc. after this control are various other controls allowing me to enter the name of the artist, album, track etc.
What i want to do is write a bit of code that makes certain controls visibile or invisibile depending on the combo boxs value. i was thinkng along the lines of
private sub Combo0_Change()
If Combo0.Value = Album Then
txtAlbum.Visible = False
End If
End Sub
which obviously doesn't work, can someone point me in the right direction to make this code work. PLEASE its driving me insane
I have a form that allows music albums and tracks to be stored along with their location etc. On the form the first control is a combo box which looks up a value from another table in this case it is the music category i.e. album, r & B, compilation etc. after this control are various other controls allowing me to enter the name of the artist, album, track etc.
What i want to do is write a bit of code that makes certain controls visibile or invisibile depending on the combo boxs value. i was thinkng along the lines of
private sub Combo0_Change()
If Combo0.Value = Album Then
txtAlbum.Visible = False
End If
End Sub
which obviously doesn't work, can someone point me in the right direction to make this code work. PLEASE its driving me insane