Access VBA and Macros

[orangeman2003]

Hi,

I am extremely elementary at VBA and I'm not sure I need it here but I'm stuck and could use help. Basically I have a form that has a bunch of checkboxes. I have had success with assigned or rather 'embedding' macros in a checkbox. I don't like this because every time the user clicks the box an action occurs rather than all at once. Basically I want to have a button that says something like 'execute' where let's say I have 10 check boxes and 4 of them are checked or true. when I click that button I want all the macros for those selections to run. However, because most of my macros are embedded within each checkbox I cannot figure out how to call them by name.


something like... IF checkbox is true then execute embedded macro for checkboxes x, y, z, etc., but do nothing for a box that is NOT checked.



Thanks!

[June7]

Don't have individual macros. Put all code into the button macro.

I don't use macros, only VBA.

[orangeman2003]

I'm not advanced enough to do that. Basically I have to create a macro, convert it to VBA (this part isn't hard) but then the hard part is putting into a sequence of code that works.

[June7]

If you want VBA why do you have embedded macros?

The button click code could be like:

If Me.check1 Then
'do this
End If

If Me.check2 Then
'do this
End If

etc.