Overwriting specific data fields in a specific record of a table

G

Guest

I am developing an application whereby an organization can manage it's
performance measure definition structure. Each measure definition record
contains 50+ data fields. When a change is requested/recommended, a copy of
the mesure definition record is appended to a "recommended changes table",
from which the approval process is monitored.

If the change is approved, the change record (with changed data) needs to be
moved back to the definition table. The simplest way would be to delete the
old definition record, and append the change record. However, because of the
relationship and Primary Key structure that I really don't want to change,
the macro step that calls the delete query produces and error and prevents
the delete.

Is there a non-VBA way to overwrite the data in the record in the definition
table? I've thought of opening a form that displays the record in question,
and then executing a SetValue step for each field. I'll do it, if that's the
only way, but if there is something less cumbersome, I'd prefer to do that.

Thanks,

Paul Legler
 
G

Guest

If you do have some sort of 'approved check' you could create an Updatequery
for this task and run this. That way the data is updated if it is approved
and otherwise it won't. Creating the query would take a little time to set up
but after that it is just activating on demand.

hth
 
G

Guest

Maurice,

Thanks, hadn't even thought of that. Forest for the trees. You're right,
it will take a little time to set up, but it isn't hard. Thanks again.

Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top