cmrabide
07-20-2000, 11:25 AM
I know this can be done, just not sure of the syntax...I have a form for data entry, and I want certain text box fields to be visible depending on the selection in a drop down box. I have managed to get it to work, but it affects the visible property of that field(text box) for every record all the way down the page. I only want it to make a text box field invisible for an indiviual record. Thanks for the suggestions
Chad
TommyIndigo
07-23-2000, 07:01 AM
The visible property can be programatically set. Write a little code that is triggered by the OnOpen and AfterUpdate (of the combo box) events on the form...
For example, if the text box should be visible while "green" is selected in the combo box, but invisible while "red" is selected, it would look something like this:
IF Me.Combo1="green" THEN
Me.Text1.Visible=True
ELSEIF Me.Combo1="red" THEN
Me.Text1.Visible=False
END IF
I'm doing this based memory (not tested) so you may need to play around with it, but that's the basic structure