continuous form

L

Luis

Hello.
I have a continuous form with a variable number of lines. For each line this
form has 2 textboxes, one with a code and one empty.
What i need to do is to loop through each line and get the value of textbox
number one. Then i perform some actions and the textbox two is filled with
the resul of the action performed.

Is this possible ?

Thanks.
 
A

Alex Dybenko

Hi,
you can open a recordset, based on form's Recordsetclone property,
then loop through it using:
do until rst.eof
'do your actions here
rst.movenext
loop
 
S

Steve Schapel

Alternatively, depending on what specifically you mean by "perform some
actions", this could be a job for an Update Query, or for a calculated
field in a query or the Control Source of the textbox.
 
Top