Programatically Update Multiple Tables from one entry Form

[PMB]

Thank you in advance for any and all assistance.

I'm running a form/table that tracks transactions and I want to update a
daily and monthly table at the end of each transaction based on the
CustomerID <> CASH or <> CCARD. Which should give me only the accounts that
charged products or services.

I would like to do this as transparent as possible as not to alert my clerks
to the update procedure. Is there a way to programatically open more than
one table and update the same fields in them?

Michael

[Pieter Linden]

"PMB" <pm*****@megavision.com> wrote in message news:<Kb****************@news.uswest.net>...

Thank you in advance for any and all assistance.

I'm running a form/table that tracks transactions and I want to update a
daily and monthly table at the end of each transaction based on the
CustomerID <> CASH or <> CCARD. Which should give me only the accounts that
charged products or services.

I would like to do this as transparent as possible as not to alert my clerks
to the update procedure. Is there a way to programatically open more than
one table and update the same fields in them?

Michael

normally you'd use update queries...

docmd.setwarnings false
docmd.openquery "myupdatequery"
docmd.setwarnings true

[gus kernot]

Michael

Forgive me if I have mis-understood you, but I suspect what you propose
is over complicated.

If you want to track transactions on a daily or monthly basis how about
putting the date and other required data in you main table and then,
when you want the information do a report based on a query from that
table.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!