Copy data Fields on a form to Field on a Table

[Hishow]

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

[Seth Schrock]

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.

[Rabbit]

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.

[Hishow]

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

[Rabbit]

I didn't say it was impossible. I'm saying good design recommends that you don't do that.

[Hishow]

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.

[Rabbit]

Glad you got it all sorted out! Good luck on the rest of your project.