update multiple records in multiple tables from one form

[Anj01]

hello

I have been trying to run multiple update queries based on the data entered by
user.

Brief background:
I am fetching data from various tables using a single query (for a date).
Each row consists of 5 text boxes whose data can be edited / entered
The form is submitted using 1update button

if the data is changed in Txtbox 1 , txtBox2 -- it updates Table 1
TxtBox3, txtbox 4 --- update table 2
txtbox5 updates table3

Problem:
At a single time there can be many rows of data . The data updates page is
fast if there are only a few records on a given date. Whereas if the number of
rows fetched is even 50 it takes at least a minute to update.
Please tell me how can I minimise the time.

Also will setting a flag whenever a textbox change occurs so that the updates
page knows which rows were edited help ?
if yes, then how do I do this

Thanks

[The ScareCrow]

Need more info

CF version ?

DB ?

Ken