subform full of checkboxes

[Auburnsp]

I need to make a form that lists 120 checkboxes and then adds an associated value to get a total.

I have a table with Description field (i.e. aspirin) and a Points field (i.e.2)
I need to make a subform that shows 120 checkboxes and when the user checks the boxes the associated points are totaled.

I have tried using a default value for each checkbox which works except I can't get the subform to add a new record when I move to the next mainform record.

Am I on the right track or can anyone help with how to make a form where I can see all 120 items and give the use a choice to check 1 or all of them and get a total?

Appreciate any help at all.

 

[missinglinq]

You need to give us a better, plain-language, explanation of what you're trying to accomplish, here, and some idea of you overall data scheme.

But most experienced developers are going too tell you that a Table with more than 25-30 Fields is almost always indicative of an database that is not Normalized.

Linq ;0)>

 

[nanscombe]

Almost sounds more akin to a spreadsheet, in which case normalisation probably wouldn't help.


Is the form going to try and use multiple records to supply the labels and weighting (points) for each of the checkboxes?

ie:
record 1 - Checkbox label 1 (Description) - checkbox weighting 1 (Points)
record 2 - Checkbox label 2 (Description) - checkbox weighting 2 (Points)
record 3 - Checkbox label 3 (Description) - checkbox weighting 3 (Points)
...
record n - Checkbox label n (Description) - checkbox weighting n (Points)

But all on a single form?

 

[Auburnsp]

I have a list of 120 items and each has an associated value - a point.
I have put them in a table 2 ways -
first in a table where each record has 2 fields - description and point value
second I tried a table where all 120 are listed as separate Y/N fields with a default value of whatever the associated point value is.

The second one worked when making the user form but it will not add a new records when I move to the next record in the main form.


X Aspirin 1
x critical care 3
x emergency services 2
_ bandages 2
_ antiseptic 5

Total: 6

I need to make a subform that the user can use to check any or all of these - one form for each record in the main table - and have just the point value add to a total.

I added a shot of my current form (which works except it won't add a new record when I link to the master form -

Am I more clear? Truly appreciate your help.

 

[way2bord]

Add the MapID and a yes/no to your table... ie: MapID / itemname / pointvalue / chkbox

Run a query to Select pointvalue where MapID = V**** and chkbox = true, then dsum the resulting recordset into Audited text box.

You'll run into a lot of trouble with a continuous form if the checkboxes don't exist in your table.

 

[Auburnsp]

I will try that - thank you so much for your help! Will report back as soon as I have a result