Adding values to checkboxes

[zero3ree]

Hello,

I am trying to set up a estimation form. What I want to accomplish is to have multiple checkboxes that a user would select the boxes relevant to his project. From these selections there would be a sum created. Each box could have different values. I tried using the default value but when I unchecked and rechecked it went back to using -1.

I am thinking I will need to assign values through a query but I want to show the sum on my form.



Any help would be appreciated.

[ranman256]

check boxes are only ON or OFF. they dont have anything else.
now, OPTION buttons can have different values.
put them into a frame
ex: the frame fraPARTY
would have options buttons inside the frame
REPUBLICAN
DEMOCRATE
INDEPENDENT
OTHER

set the repub opt value = 1
demo = 2
etc
THEN whatever gets picked the value is passed to fraPARTY.value. THIS is what is stored in the table.

[zero3ree]

Thank you. I will try that out.

[ssanfu]

You have said HOW you are doing things, but not WHAT you are trying to do. Not really enough info provided......

Is the estimation form bound?
How many check boxes are there on the form?
Do you want to save the values or the total estimate or both?
How often will the values change?

I'm thinking the option group won't work. I would put the values in a table and use VBA to populate text boxes on the form.

[zero3ree]

I am still trying to figure out how to put it together. This was a conceptual idea. The main goal is to have a unbound form for the user to check some boxes and get a estimated amount of hours. I make bound it though so they can come back to it per project. Say the form would have 30 boxes that represent tasks that can be done. The user only does 5 so they check the 5 related boxes and predetermined hours for each task are summed up for a total hours to do the project.

[Micron]

If you use checkboxes, you will need a companion control (textbox) that holds the value you want to add. This control does not have to be visible if that is preferred. Your query or code could sum the values of txtValue IF checkbox = true and your form can be bound to a table or query as you wish. However, I'm not sure how you'd associate the textbox to any given checkbox, unless maybe this is done on a continuous form. It should work in that case, as each checkbox and option button is associate with the same record. I suppose you could put the value in the control tag and add it from there as another method.

If you use option buttons, you cannot place them in a frame because a frameset only allows one to be selected. You could place them within a rectangle that looks like a frame (etched border, transparent background) or just by themselves. You will have to loop through the form controls, looking for the option type of control, checking if selected and summing the default values as you go by writing something like:

If Me.Option13.Value = True then intSum = intSum + Me.Option13.Defaultvalue

Obviously you cannot refer to them by name in a loop. I'm just showing the properties you need to use. I guess you could also store the Option.Value in a table through code by writing 0 (false) or -1 (true) and read that value when re-opening the form (again, in code), but I don't think you can bind them.

[zero3ree]

I thought the option tool was a good canidate but I was not able to unselect the option. I need that flexibility like a checkbox has. What I ended up doing was adding the checkbox with the companion textbox like Micron mentioned. Then i added a sum textbox that only adds the hours if the checkbox is checked. This will work for what I am putting together. I thank all of you for your suggestions.