Software

Ask something
Discussion Locked

MS Access - Update Records

0 helpful
3 replies

by jgreer

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am currently working on a database that processses reports and sends them out automatically. However, I need it to update the records with a closed status and date. I cannot seem to make Access complete this task. When I have it run a set value with a macro on the form it says it cannot update the records and I think this is related to two queries being required to locate this information. I attempted to utilize an Update Query however, it cannot seem to locate the records in order to update them. Any ideas?

3 replies

by techrep

Although I do not quite understand your situation, it seems that you are using a query as the recordsource for your form that links several tables, and that produces a non-updateable recordset. You could try running your query separately from the Query tab and when you get the results, try to change a value. If the query is not updateable, it'll tell you that. Otherwise, the change will work.

If not updateable, you need to look up the record that contains the fields you need to update in a separate procedure (perhaps in the form's afterupdate event. There are several ways to do this but a macro probably won't work. You need to write some go old Access BASIC code.

Perhaps you can tell us some more specifics.

This discussion is closed to new replies.