I’m really stuck on how to create: Check Boxes/Option button/Option Group in VBA.

Could someone help on either all of them or some of them please?

Thanks

Richard

When you say you want to create them in VBA, do you mean you want to create them programmatically? Can you create a stored form instead? Why would it need to be programmatic? You can do this, but it is more of a VB.Net thing. Access allows you to create plenty of forms and store them in your database.

When you create the controls, you also have to place them and set their properties using VBA as well. What do you want them to do, and how will the properties be controlled? (Where will you get the property values?

In the rare cases that I have had to do this in Access, I usually create the controls (more than I need) and place them on the form, then position and enable them as needed based on values from a previous operation.

mmcdonal

Look it up at: http://wrox.books24x7.com