loop through form controls 2

[hirenJ]

Hi All,

I am writing some code for a form that contains UnBound controls --

I need a bit of code that will loop through all the txtBoxes, combo's etc, and store their value as into a variable --

any ideas?

Thanks

Hiren

)

 

[jebry]

Hi Hiren!

Try this:

Dim cntl As Control

For Each cntl In Me.Controls
Select Case cntl.ControlType
Case acTextBox
Do your text box stuff here(check the name using cntl.Name)
Case acComboBox
Do your combo box stuff here
etc for acCheckBox or acRadioButton or acListBox
End Select
Next cntl

hth
Jeff Bridgham
bridgham@purdue.edu

 

[hirenJ]

thats spot on!!! thanks a lot man!!!