Updating unrelated tables

[Ryker]

I have two unrelated tables.

tblPO
tblEADemographics

I have a purchase order form containing the usual fields, but the
following three I need to focus on. ClientSocial, Total, and
VendorName.

When the po is printed, (I have code that prints the current po) I
would like to take ClientSocial and find the matching SocialSecurityNo
in tblEADemographics and copy data from Total and Vendorname into the
fields PaymentAmt and Payee located in tblEADemographics.

Could a query do this, or can it be done in code, or is it possible to
do?

Thanks

[salad]

Ryker wrote:

I have two unrelated tables.

tblPO
tblEADemographics

I have a purchase order form containing the usual fields, but the
following three I need to focus on. ClientSocial, Total, and
VendorName.

When the po is printed, (I have code that prints the current po) I
would like to take ClientSocial and find the matching SocialSecurityNo
in tblEADemographics and copy data from Total and Vendorname into the
fields PaymentAmt and Payee located in tblEADemographics.

Could a query do this, or can it be done in code, or is it possible to
do?

Thanks

An update query would work fine. I'd suggest you run it outside of the
report.

Create a new Select query, get it to select the right records, then from
the menu select Query/Update and then enter the update values.