Recordset not updateable

[Guest]

I need to match transactions in one table with confirmations from a vendor in
a different table. The confirmations do not come back with anything other
than a description, price and date.

What I am trying to do is match all my un-confirmed transactions with those
that are coming in. I have nothing other than the price field to match these
up with.

What I have done is created a form that is based on a query that matches
these two tables up based on price. This query GIVES THE ERROR: RECORDSET IS
NOT UPDATEABLE. The form shows these transactions side by side. What I want
to be able to do is, in the form, click on a button if I agree they match,
and that button checks a box in each table that they matched.

I have created little forms, that will open based on link criteria, based
only on their underlying tables, so I can change the data. same error:
RECORDSET IS NOT UPDATABLE. But if I open the form directly, the data is
updateable (duh - it's based on a single table; no filters).

HELP!!!! I"m about to pull my hair out. After reading all the other
similar posts, I think I have a relationship or join issue, but I don't know
how to fix that.

Any help is appreciated!
ljvincent(removethis)@email.uophx.edu

 

[tina]

suggest you try using two Update queries. make sure that both tables have a
primary key field. if they don't, add an Autonumber field to each table and
designate it as primary key in each table (recommend you give the fields
different names); this is simply so Access can identify each specific record
in each table. next, make sure that the primary key field of each table is
included in the matching query that your form is bound to.

when you click the "yes, this pair matches" button, use a macro or VBA to
run an Update query on each table, as

UPDATE Table1 SET MatchedCheckbox = True
WHERE PrimaryKeyField=[Forms]![FormName]![PrimaryKeyField];

UPDATE Table2 SET MatchedCheckbox = True
WHERE PrimaryKeyField=[Forms]![FormName]![OtherPrimaryKeyField];

hth