Updating a unmatched query

[mmcov]

Hello everyone

This is my first post on this forum so I was wondering whether you guys could help me.

I import data from a server daliy. My DB has three tables containing print files;

Print: shows leaflets that have been printed
Package: shows leaflets that have been packaged
Dispatch: shows leaflets that have been dispatched

Since data can only be imported at the end of the business day, I needed to create a query which will show the files that have printed but havent been packaged. To do this I created an unmatched query and tested it, it works fine.

This unmatched query has now been placed in a sub form, I would like the users to add comments next to the rows in the queries. However since the unmatched query cannot be updated I was wondering if there is any way of around it

Thanks guys

 

[namliam]

You have your unmatched query... have it ONLY return your Primary key (PK) of the table.

Now make a new query, based on the table you want to update.
In the criteria of the PK put something like:
In (Select PK from UnmatchedQuery)

That should do the trick.

 

[mmcov]

Thanks for your reply. Ive tried that but again its not letting me edit...any other ideas? Thanks

 

[namliam]

Uhm... that should work... I will try later and get back...