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
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