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

Update multiple tables from one form

P: n/a
CS
I need to update multiple tables from one form using a command button. The
info from the different text boxes should then go into the tables.

Can someone help me with some example code on how to do this.

Feb 11 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

CS wrote:
I need to update multiple tables from one form using a command button. The
info from the different text boxes should then go into the tables.

Can someone help me with some example code on how to do this.


the easiest way would be to make multiple update queries that update
the different tables. then in your code you would have:

Private Sub btnUpdate_click()
docmd.openquery("queryname here")
docmd.openquery("other query name here")
end sub

there are many other ways to do it but this is by far the easiest.

Feb 11 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.