Refer to combo box in a series that depends on variable. 1

[NewTexican]

Ok, I have a column of comboboxes combo11, comb012, ..., combo16. These boxes are next to text11, text12, ..., text16. Thanks to Roy vidar I have a public sub which contains.

mlout = Val(Right(Screen.ActiveControl.Name, 2)) - 10

gives me 1, 2, ..., 6 which I save in a field of a record with an onclick event.
Before I save I want to grab the value in the corresponding combo box and put that in the record as well.
How do I refer to the value in the combo box using mlout so I can assign it to the variable addtype?

addtype = me.combo(mlout + 10).value !?!?!?! (something like that)

thanks in advance.

 

[PHV]

addtype = Me("combo1" & mlout).Value

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[NewTexican]

too easy, man thanks I was not going about that the right way.