continuous form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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.
 
Back
Top