Hi!

Got a question regarding recordsource of forms...
In access, when we assign the recordsource of a form to a table,
any updates by the user on the form is immediately propagated to the table.

How do we break this chain? i.e., how can we, after fetching the data from the underlying table, block any write to the data, until the user clicks on a save button?

Thanks in advance!



Scripts82

__________________
Scripts82

The way to do this is NOT to set the control source of the form to the table. Make the form UNbound. You then populate the form with a COPY of the data in the table. You work with the copy and then after you're done with one of its records your save button will then take the local copy of the info and send it to the table itself.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thanks SerranoG
i get what you mean.

But, I can do that with Single Form view.
All the examples that I find from books are only using "Single" form view.

How do I do it for continuous form view?

Thanks in advance!

Scripts82

You're in luck. The view doesn't matter. The approach and outcome will be the same. Work with an unbound continuous form, make a copy of the recordset and make that the record source, work with the copy, when done, write the updated data back to the table.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thanks! I will look into that!

Scripts82