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

<<Help>> !! with copying the info on a form to a table.

P: n/a
Greetings,

I have a form that is bound to a table that has about 15 fields in it
and all of the fields are displayed on the main form. I have 4 fields
that will be updated and I want to write that information to another
table that only has only these 4 fields in it. Since the form is bound
to one table, how can I write these 4 fields to a different table.
These fields will be written when on on click event occurs on a button.

Any help would certainly be appreciated.

Thanks
Chuck

Jun 5 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

WCBF wrote:
Greetings,

I have a form that is bound to a table that has about 15 fields in it
and all of the fields are displayed on the main form. I have 4 fields
that will be updated and I want to write that information to another
table that only has only these 4 fields in it. Since the form is bound
to one table, how can I write these 4 fields to a different table.
These fields will be written when on on click event occurs on a button.

Any help would certainly be appreciated.

Thanks
Chuck


Use DoCmd.RunSQL and then create your insert statement and run it or
use a recordset.

then attach to the click event of your button.

Jun 6 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.