Help with Check Boxes and Sub Forms

[SimontheSkater]

So, I have an issue. I have a form with a sub form but for each line I need a checkbox. When a checkbox is placed, it is duplicated and functional as one checkbox. If I click one checkbox, they are all checked. I need some way to get them to separate. Is there any way with VBA for when the duplications occur that the name of each check box created gets changed? I'm assuming this is the reason that they all function as one, because they all are just one checkbox (Duplicated). For the most part they are NEEDED for a visual, no true functionality.

 

[Gasman]

Why are you crossposting in other forums?

 

[SimontheSkater]

I am new to forums, I did not know this was taboo.

 

[theDBguy]

Hi. Welcome to AWF!

You must be using an unbound checkbox instead of a bound one.

 

[SimontheSkater]

what would you suggest, I don't really want to tie the checkbox to the data. It is for mere visual verification.

 

[theDBguy]

what would you suggest, I don't really want to tie the checkbox to the data. It is for mere visual verification.

Another option then is to use vba.

 

[SimontheSkater]

Is anyone able to help with this VBA Code?

 

[theDBguy]

Is anyone able to help with this VBA Code?

Check here...

Post in thread 'Manipulating an independent check box field in a form'

Sep 9, 2022

There are several methods
1. Add the boolean field to the table itself
2. Create a temp table
3. Make a disconnected recordset
4. Somewhere store the selections. This can be a table, string, collection, etc. Then use a function to set the value of the checkbox based on if the value is stored

I created a checklist class so I can create anywhere a checklist like this with a couple lines of code.
0. Add the class to your project
1. Need to add an unbound checkbox to the form
2. Set the checkbox's control source to the function
=IsSelected([PrimaryKeyFieldName])
where PrimaryKeyFieldName is the actual name...

• MajP

• 

 

[MajP]

I think my post covers most possible ways to do it. The pros and cons are listed. So for more help you will need to provide more details on what you will do with the checks. If you do not need to persist the selections you have more options.

 

[SimontheSkater]

PersonnelSelector.Initialize Me.chkSelected, "Serial", "Serial" I get Run Time Error 424 Object required

 

[Pat Hartman]

what would you suggest, I don't really want to tie the checkbox to the data. It is for mere visual verification.

When the checkbox is not tied to the data, it will duplicate on a continuous or datasheet form. Why? continuous and ds forms are simply single forms that are repeated. Each form has only ONE set of variables. So, if you changed the label of a control, it would change for all controls. Since the checkbox is not bound to the data, it works like a label would. It is just another constant as far as Access is concerned.
MajP offered several options to solve the problem.

Another option, might be to use a multi-select listbox to check the items. This is far less flexible than a form and would only work for you in limited situations.

 

[MajP]

PersonnelSelector.Initialize Me.chkSelected, "Serial", "Serial" I get Run Time Error 424 Object required

Without seeing your code my guess is you did not instantiate at the top of the module the class

Option Explicit

Dim PersonnelSelector As New Record_Selector

Private Sub Form_Load()
  Me.ID.SetFocus
  PersonnelSelector.Initialize Me.chkSelected, "ID", "ID"
End Sub