scan through and update records in a tabular form

[Guest]

hi there,

I have built a tabular form with dummy fields which I would like to use as
update once the update button is clicked. How can this be done?

Thanks in advance.

 

[John Vinson]

hi there,

I have built a tabular form with dummy fields which I would like to use as
update once the update button is clicked. How can this be done?

Thanks in advance.

I'm sorry, I don't understand the question. What do you want to
"update"? What is a "dummy field"? Why not simply use a standard form
bound to your table?

John W. Vinson[MVP]

 

[Guest]

The reason is I want to give the user the feasibility to undo what they have
done to the records when they exit the form.

So what I have tried to do is to make a form base on a query with the
underlining data table joined to a dummy table with fields that I can use for
temporary storage. Then when the form is opened, I will like to scan through
all the records come up and store the original value to fields from the dummy
table and allow users to work on the form. On exit, if user want to cancel
all the changes, the program have to scan through all records again to
restore their original values.

Cheers.