Calculate

  • Thread starter Thread starter EMILYTAN via AccessMonster.com
  • Start date Start date
E

EMILYTAN via AccessMonster.com

Below are my VBA coding:-

Sum=sum+1
Me!QtyKitted = sum

My textbox is QtyKitted.

But the problem is my control source is QtyKitted because I need to use it to
generate query.

May I know how to make the textbox to accumulate?

Eg QtyText Box = 1 QtyKitted=1
QtyTextBox = 4 QtyKitted=5
 
Hi Emily,

Sum is a reserved word in Access, please rename this variable.
 
You must log in or register to reply here.

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

Top N values using textbox 1
A Continuous form field question 6
TextBox Object Control Source Expresion, trouble with 3
PowerPoint Shuffle (swap) objects on PPT slides with the same name only 0
Null Value in Subform Total 4
Pivot table calculated field Count(field) / sum(field) 0
Keeping Values in Control Source 3
Count subform records where txtCount = 0 1

Back
Top