Getting a checkbox name dynamically

  • Thread starter Thread starter Simone
  • Start date Start date
S

Simone

Hello

I have a form that gets built dynamically so I never know that the
checkbox names will be.
Once users check a check box and click submit I need to know what
check boxes are checked and run an insert query that sets a fieldname
= values (checkboxName). I don't know how to get a check box name that
is selected ..
let's say I would like to check all check boxes checked run through my
loop and insert each ID of each check box in my table. Activecontrol
won't work since I will be clicking a button.
Any ideas

Thanks.
Simone Dupre
 
If you know enough to build a form dynamically, surely you know how to loop
through the form objects collection and return just the checkboxes ?

Dim ctl As Control
For Each ctl In Me.Controls
If ctl.ControlType = acCheckBox Then
Debug.Print ctl.Name
End If
Next


Are you aware that a form can have no more that 754 objects added to it
*over its entire life* ? So so avoid a crash you have to destroy the form
and re-create it from scratch in each instance of Access.

A simpler/better way is to create enough controls on a form to suit all
forseeable needs, and just make the ones you want visible when and where you
need them.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Hi Adrian.

There is not ctrl."name" in drop down method list.

thanks anyway.. please let me know if you have any other ideas.
 
All controls have a name. Did you try the code ?

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
thanks I finally got it.

Adrian Jansen said:
All controls have a name. Did you try the code ?

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
Click to expand...
 
Back
Top