Appending unbound textboxes to another table

  • Thread starter forcefield via AccessMonster.com
  • Start date
F

forcefield via AccessMonster.com

I have a subform bound to tblB. The fields in subform are
PrevQty ,BadQty. The unbound textboxes in the footer of the subform
consisting of txtSumPrevQty, txtSumBadQty are sum of those fields
respectively.
i.e the control source of txtSumPrevQty is Sum([prevQty]) and so on. Also
there is also an unbound text box " txtAppendDate " for the date of appending
to another table. How do you append those unbound text boxes ( txtSumPrevQty ,
txtSumBadQty and txtAppendDate) to another table tblC?

Thank you for your help
 
R

ruralguy via AccessMonster.com

Using an append query, either dynamic or static. I lean toward a dynamic
query here. What are the names of the fields in the tblC table?
I have a subform bound to tblB. The fields in subform are
PrevQty ,BadQty. The unbound textboxes in the footer of the subform
consisting of txtSumPrevQty, txtSumBadQty are sum of those fields
respectively.
i.e the control source of txtSumPrevQty is Sum([prevQty]) and so on. Also
there is also an unbound text box " txtAppendDate " for the date of appending
to another table. How do you append those unbound text boxes ( txtSumPrevQty ,
txtSumBadQty and txtAppendDate) to another table tblC?

Thank you for your help
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Search using a combo box and then creating a report. 4
update textbox with total 9
How to create an unbound Subform related to an unbound Text Box 5
Appending tables 0
How force table update when no bound field updated? 1
Form design to add data to 3 tables in "Order Entry" style db 1
formating an unbound text box 1
Total on subfrom to mainform 2

Top