Getting a value from a Snapshot query into a field in a form

ForcedToUseIt

Registered User.
Local time
Today, 07:58
Joined
Jul 25, 2004
Messages
34
How can i get a value from a snapshot query and put that value into a field in another table?

The snapshot query is like this (qrySnapshot):

DocID
NewReference

And the table has fields like this (tblDocs):

DocID
Reference.
...

I want to press a button and through VBA put the (text) value in NewReference into the field in Reference where qrySnapshot.DocID = tblDocs.DocID.
I have a field on the form that shows this tblDocs.DocID and i want to use that value to compare with the qrySnapshot.DocID value.

To accomplish this I think I have to run the query form vba and get the value through it somehow. Any ideas are welcomed

P.s. Im using DAO

Thanks alot
 

Users who are viewing this thread

Back
Top Bottom