By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,446 Members | 3,120 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,446 IT Pros & Developers. It's quick & easy.

Access 97 - Update Multiple Tables from one form

P: n/a
PMB
Thank you in advance for any and all assistance.

I have a small program that I'm tracking accounts rec. and I want to keep
data, stored by day and have a month end.

I have a form called TransactionsNew that has a child form called
TransactionsNewDetails. I get a total from the child form to the parent form
just fine.

What I want to do is take four fields and update three tables. How do I do
this?

TransactionID
CustomerID
TDate
Total

I want to be able to do this, without a command button, if at all possible?
In say an afterupdate or lostfocus etc.

Michael
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.