Sum of multiple textbox in form

[djossh]

Hi, how to write VBA code to sum "textbox1" to "textbox20" based on Criteia in "textboxA" .. I know I can use "IF" function but it will be very long formula since I'm going to add 20 textbox.. I'm new to VBA.. thanks..

 

[Alansidman]

Try using the Case Select instead.

Look here.
http://www.techonthenet.com/access/functions/advanced/case.php

 

[djossh]

Try using the Case Select instead.

Look here.
http://www.techonthenet.com/access/functions/advanced/case.php

That was really helpful, thanks.. I really appreciate it.