Looping Question

[barbs2]

I am trying to create an order form in Vb. There are text boxes to allow for the entry of quantities of a product required. However they will not all be used all the time so I need a way to save info. from only the full text boxes to the database. Any ideas?? I tryed a loop using a counter but couldn't get it to work and I don't want to use loads of if statements if possible.

 

[LazyMe]

You could add the textboxes to an array and loop through that array while updating.
Greetings,
Rick

 

[john24]

you could try something like:

Dim TestText As String
Dim MyTextBoxes As TextBox
For Each MyTextBoxes In frmMyForm
TestText = MyTextBoxes.Text
MsgBox "text: " & TestText, vbOKOnly
Next