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

Copy data Fields on a form to Field on a Table

P: 14
I have some fields on a form that are not related to any table. They texbox used for calculations. I want to copy some of these fields to a table. Example. FormA has (Field1, Field2 and Field3). Then i want to copy these 3Fields in FormA to TableA (Field1, Field2 and Field3)

Thank you in advance
Jan 24 '15 #1
Share this Question
Share on Google+
6 Replies

Seth Schrock
Expert 2.5K+
P: 2,951
The easiest way (and usually the best way) is to make the table the record source for the form and then set the control source for each textbox to be the field that you want them tied to.
Jan 24 '15 #2

Expert Mod 10K+
P: 12,430
If it's calculations, there's no need to store them. It's usually better to calculate it as needed so the data is accurate.
Jan 24 '15 #3

P: 14
OK even if I cannot copy fields from to table, Is there a way I can first copy selected field using button and use another button to paste those fields into a table

Many thanks
Jan 25 '15 #4

Expert Mod 10K+
P: 12,430
I didn't say it was impossible. I'm saying good design recommends that you don't do that.
Jan 25 '15 #5

P: 14
Thanks so much. Now what I did: I placed few data on the table, then used Query(Query1) to do all my calculations. Then used another query(Query2) to extract(from Query1) those fields i actually need. This works for me perfectly.

Thank you all.
Jan 29 '15 #6

Expert Mod 10K+
P: 12,430
Glad you got it all sorted out! Good luck on the rest of your project.
Jan 29 '15 #7

Post your reply

Sign in to post your reply or Sign up for a free account.