Preview Updates before Updating Table

[snoopy92211]

Ok. I have a doozy of an issue.

I have a table, tblobligation. I want my users to be able to make changes to this table (using a form to query the info they need), but before the changes are made, i want the changed information to be added to a stage table. that way,the approver can review the changes and decide to update or keep as is.

Does that make sense?

The query works fine, it's just that certain fields need to be locked to prevent users from changing information one into the database. It is at the Reviewer's discretion to accept or deny the changes. How the heck can I do this?


Thanks for your help!

 

[x0reset]

First, create an empty table with the same fields as the source table you want to edit, maybe call it something like TEMPtblobligation.

Next, create a parametric append query. Your users will specify the criteria to select the records from tblobligation they need to edit, and the append query will write said records to TEMPtblobligation.

Next, create a form to edit the data. Base the recordset of the form on TEMPtblobligation. Then just open the form and let your users edit away. DONT let them edit the primary key.

Finally, create an update query relating the primary key in TEMPtblobligation to the original (and matching!) primary key in tblobligation. After your approver reviews the data, he can run the update query to make the changes to tblobligation, then delete the records from TEMPtblobligation.

Hope this is what you needed.

 

[snoopy92211]

Thanks for the reply. Now here's my next question.

So the user uses my form to query the records they want to update. What I would like to be able to do is have the user select the exact records they want to track.

For example, if Suze queries on all fields containing apples within a date range of 1/3/06 and 1/9/06, that doesn't mean that she actually wants to update all of these records.

I want suze to be able to select what records to update, then go through with updating to a temp table, and on from there.

Thanks!