The following code i have to loop thru the table in a form to add up all the size Qty's (20 sizes).
Is there a way to do same in a recordset to loop thru the same way? (e.i ctl.name and ctl)
If yes can you give me an example.
For Each ctl In frm.Controls
If Left(ctl.Name, 2) = "SH" Then wQty = wQty + Nz(ctl)