Need be able to edit query 2 which has to table references

[jad73]

OK, this is kind of hard to explain, but I'll try. Basically I have two Tables. One table holds all our payment information, work orders and such. The second table has payments that needed to be updated on table 1. I have written code that compares the two table and updates the payments on table 1. I do a compare between completion date and account number (the only two fields that are usually the same). However, some of the payments information is slightly different (such as a date being off). My code updates usually 3000 or so records and leaves about 50 unupdated. It flags the 50 unupdated in the payment table, then opens a query in access for the user to see the unupdated records. It also opens table 1 with the possible matches for the unupdated ones (by account number only, usually about 3 choices). I want the user to be able to look at table 1's query to find the appropriate record that matches the payment and fix the date to the same as the payment table. Then they can run an update again and all the payments should be updated.

The problem is I cant type in the table 1 query, It says it is unable to be edited. I assume it is because it references the payment table as well to figure out which account numbers to bring up.

I know this is confusing, but I really dont know how else to explain it. Please Help

 

[allanon]

I assume that these are access tables. Some things to look at:

When displaying the records to the user check the status of the diplaying form. On the property sheet check the Allow Edits property .

If there are relationships on these tables check to ensure that the updates you are trying to do dont conflict with the relationship rules.

Check that there is nothing wrong with the setup of the tables. Seems unlike this would be an issue but who knows.

If you are linking to these tables then there are other issues to consider.