Combo box vs text box

[Amen]

i have something like this.the response(value) are my combo box



4: ID response txtbox1 textbox2 textbox3
1 jug

2 plate

3 cup

4 spoon

the text box is the one i should enter a value.if i select Cup from my drop down list..i should skip the next step and move on to step 6 since I'm in step 4 now..my step 5 should turn invisible(combo box and text box)
can someone share some lights here

[ItsMe]

I have no idea what you are trying to say. You can use the "AfterUpdate" event of your combobox to adjust the properties of various controls on your form.

If me.ComboBoxName.Column(1) = "Cups" then

Me.Step5.Visible = False

End If

[Amen]

thanks

i want to include 2 values eg If me.ComboBoxName.Column(1) = "Cups" and "spoon" then..

when i add "spoon" use AND or OR i got an error..

whats wrong with my code..

thanks

[ItsMe]

ComboBoxes return only one row. You can choose which Column you want to retreive the value from. Example .Column(0) or .Column(1). You can retrieve the values of multiple columns too.

strColumnZero = me.ComboBoxName.Column(0)
strColumnOne = me.ComboBoxName.Column(1)

After you make a selection with your combobox, the value of your combobox is equal to the item that is selected.