Combo box problems

[mercury]

There are five combo boxes cbo1,chbo2,cbo3,cbo4,cbo5. The user is suppose to select a choice from each combo box and when a button is clicked a textbox is suppose to produce a cost and your selection.

e.g. P L E A S E S F A

txt1= PLEASEFA cost=$13.00

Im just trying to get the textbox working(txt1) I used this code

If cbo="P" AND cbo2 ="L" And cbo="E" And cbo4="A" And cbo5-"SFA" then txt1="PLEASESFA"
End if
End sub

This isnt working Do you all have any idea why not?

Also is there any easier way to do this because i have alot of selections in these combo boxes which means loads of combinations.

 

[Newman]

txt1 = cbo1 & cbo2 & cbo3 & cbo4 & cbo5

 

[mercury]

Hi

I tried what you suggested but the thing is i keep getting a number and not the selections i made in the text box.
I have posted it just in case anyone has anymore ideas.Thanks Alot though
What is supposed to happen when a person selects a choice from the two textboxes, those choices should appear in the textbox concatenated or joined.

Mercury

 

[RallyXS]

Try changing your code as this:

Private Sub Command39_Click()

txtprescription = Combo28.Column(1) & "-" & Combo30.Column(1)

End Sub

 

[mercury]

Thanks alot that worked.

Mercury

 

[mercury]

hi again,
I just wanted to know, what does column(1) do.