concat combo box values

[vijay]

Hi All,
Please help with the underlying problem.
i have 2 combo boxes.
combo_box1 of them has values "january","april","july" and "october".
combo_box2 has values 2001,2002,2003.
after the user selects the values,i need to concat the values,and store it in an underlying table as "01-combo_box1.value-combo_box2.value".

Thanks

 

[mission2java_78]

Hi All,
Please help with the underlying problem.
i have 2 combo boxes.
combo_box1 of them has values "january","april","july" and "october".
combo_box2 has values 2001,2002,2003.
after the user selects the values,i need to concat the values,and store it in an underlying table as "01-combo_box1.value-combo_box2.value".

Thanks

Why not use a calendar
?

Anyhow

try

Me.txtBox.Value = "01-" & Me.Combo1.Value & "-" & Me.Combo2.Value

 

[Mile-O]

Double Post