Need help with code - form controls

daherb

Registered User.
Local time
Today, 08:05
Joined
Sep 14, 2005
Messages
66
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
 
private sub Combo0_Change()

If Combo0 = "Album" Then
txtAlbum.Visible = False
End If

End Sub
 
OMG i'm an idiot. LOL

thanks for the response, very much appreciated
 

Users who are viewing this thread

Back
Top Bottom