Recent content by stephen

I don't want to hide the whole combo box, I want to make it so that if in combo box Body_Type="ED", then when I go to combo box Body_Size and click on the down arrow to veiw the possible choices, only the choices that are valid for the ED will be available to be chosen. The other choices that...

twoplustwo, Thanks, I'll give it a try. stephen

missinglinq, I did put it in there as well, but didn't paste that in on my reply. I was curious though, has there been an earlier or newer version that didn't require the quotes? I am using Access 2003. Thank you so much. Now I can move on to making selections grey out or not show in a Combo...

I got it working with: Private Sub Body_Type_Change() 'This code will hide or show the combo based on the selection that has been made in the combo 'Where X = the value of the field If Me.Body_Type.Value = "ED" Then Me.Piston_Ring.Visible = True Else Me.Piston_Ring.Visible = False End If End Sub

John Big Booty, My need falls into your first scenerio. It didn't work, but the field in the form disappeared, instead of showing up all the time. I just need my 'Piston Ring' Field to show when the 'Body Type' is ED. Here's my version: Private Sub Body_Type_Change() 'This code will hide or...

When a certain selection is made in a combo box on a form, I would like another field from the same table to appear. How do I make this happen?