Chkboxes taking values from a field

[andy49]

Tbl


Field one chkId auto number
Field one gpname string
Field two date checked (date)
Field three true/false true for any value in the table)




I've a field in the table which shows which groups (from 15 groups) have been checked by the user.


Group1 true
Group2 true
Group4 true
Group7 true

Etc

There are some groups which may not have been checked and I want to show these on a form with checkboxes.

So group1chk is true
Group2chk is true
Group3chk is false and so on


I have already managed to do it in Vba (bringing the table into a record set then going through each chkbox and seeing if the table is "true."

But wondered if I've missed a faster way to link the value in the field to an individual checkbox.

Thanks for any help.






Sent from my iPhone using Tapatalk

[AccessPower]

Edit: read that completely wrong.

Looping through checkbox controls:

Dim ctl As Control
Dim strListbox as String
For Each ctl In Me.Controls
    If ctl.ControlType = acCheckBox Then
        If ctl.Value <> True Then
            strListbox = strListbox & ";" & ctl.name
        End If
    End If
Next ctl

strListbox = Mid(strListbox, 2)

me.myListbox = strListbox

The code above adds the name of the unchecked checkbox control to a listbox called myListbox.

OR...

You could set the value of each checkbox as a unique numerical value. Then have them add up. With a lot of math you should be able to get the running total and determine which ones aren't checked right away. I think there are 225 combinations if you have 15 checkboxes.

[andy49]

This isn't what I'm after though.


Sent from my iPhone using Tapatalk

[andy49]

I have a table with the "trues". Just want to tick the checkboxes for these faster than running through them testing each one.


Sent from my iPhone using Tapatalk

[ssanfu]

Don't really understand what you want........

I've a field in the table which shows which groups (from 15 groups) have been checked by the user.


Group1 true
Group2 true
Group4 true
Group7 true

Etc

There are some groups which may not have been checked and I want to show these on a form with checkboxes.

Are the check boxes (ie "Group1") bound to fields in the table "Tbl"?

If they are in a different table, linked by field "chkID", then you could use a main form/subform setup. No code necessary.

You *could* post your dB for analysis.....

[andy49]

This is the table. A row is added using an append query when a member of staff checks their group.

I'd like to be able to look at the form below and see what's done. It currently works.



Group names can change from year to year which doesn't help either. (Next year there not be a "7jk/mm1")

Any questions will gladly be answered.


Sent from my iPhone using Tapatalk