forms

  • Thread starter Thread starter admin
  • Start date Start date
A

admin

i am creating a entry form for an event. there are checkboxes
throughout that have a value connected to each. when a checkbox is
chosen, i need the corresponding amount to appear in a column that
will be autosummed into a total amount submitted. appreciate any help
you can give me to make this work.
 
I think we may need a little more information. By "form", do you mean
"UserForm"? Where in this "column" (same column for each checkbox?) do you
want the value to go? I mean, will each check box be associated with a
particular cell in the column or do you want each click of the CheckBox to
put the value in the next available cell in the column? If the latter, how
do you want to handle the unchecking of a CheckBox... leave the hole it
produces in the column or close the hole up? This value that is "connected"
to each CheckBox... where is it... in the Caption for the CheckBox or in
some kind of lookup mechanism (perhaps an array)?

Rick
 
You could add some code to the LostFocus() or Change() Event of the
checkbox, when someone clicks it then it would add the value you
associated with the checkbox to the appropriate column.


HTH,
JP
 
thanks, Rick, for the quick reply. this is sounding like it may be
too complicated for me but i will try to fill in the blanks.
this is a user form if that means it will go out and be filled in by
our members, copied and submitted. the column is on
the far left of the form with a "total amount submitted" spot at the
bottom. this column, which will autosum into the
total box, has 9 possible fields to fill in. each field has from 2 -
9 possible amounts,
each with its own checkbox. if our user checks the wrong box and has
to change it, i want only the corrected, checked
amount to appear in the column/field associated with it so i guess
that would close the hole so the correct amount can
go into it. the value for each checkbox is in the caption beside the
checkbox. hope i didn't miss anything. thanks much.
Robbin

this is a bit of the form, you have to imagine there are checkboxes
below each category, going down for each player entered.
the "fees paid" area is the column to fill in. so if the first player
is entering the men/master division, $50 needs to appear in fees paid.
hope this helps.

Singles  Wed, March 10, 9am Men Women
Master Open-A Open-B Senior Novice Master Open Senior Novice
Senior
R/7 R/6 R/5 R/5 R/4 R/7 R/5 R/5 R/4 Only
$50 $40 $30 $35 $15 $50 $35 $35 $15 Age Fees Pd
Player
Player
Player
Player
Player
Player
 
Back
Top