Please help with sum on Form or advise if a better way (1 Viewer)

[Kroghr]

I have 19 combo box's with choices from 1 though 9 in all of them. I need to be able to count how many 1's 2's 3's etc etc there are under a single record

Combox Names are 2ACat, 2CCat, 3ACat, 3CCat.....


I'm using this code in the after update of the form

If Me!Txt2ACat = Null Then
Me!txt2A0 = 0
ElseIf Me!Txt2ACat = 1 Then
Me!txt2A1 = 1
ElseIf Me!Txt2ACat = 2 Then
Me!txt2A2 = 1
ElseIf Me!Txt2ACat = 3 Then
Me!txt2A3 = 1
ElseIf Me!Txt2ACat = 4 Then
Me!txt2A4 = 1
ElseIf Me!Txt2ACat = 5 Then
Me!txt2A5 = 1
ElseIf Me!Txt2ACat = 6 Then
Me!txt2A6 = 1
ElseIf Me!Txt2ACat = 7 Then
Me!txt2A7 = 1
ElseIf Me!Txt2ACat = 8 Then
Me!txt2A8 = 1
ElseIf Me!Txt2ACat = 9 Then
Me!txt2A9 = 1
End If

I've created 9 rows of 19 unbound field to capture wether the person sitting in 2A is a cat 1 or 3. I then plan on summing how many of each cat ther is per record. Problem is, its not returning to zero when i open a fresh record. Please help!

Sincerly

 

[olorin]

Hi,
It looks like you seem to be applying a spreadsheet approach to the design of your database. Databases and Spreadsheets are structured entirely differently.
How many tables do you have in your database? Are they "normalised"?