Using Checkboxes to open certain Forms (1 Viewer)

[jabaker54]

So this is question probably has a pretty basic answer...

I have 6 different check boxes that I want to attached to one button. If a check box is marked I want a specific form that is related to that checkbox to open when clicking the OnClick button.

I am not to familiar with VBA but understand macros pretty well. If there needs to be a code written I will be able to figure it out with some guidance .

Example:

[x] FormA
[ ] FormB
[x] FormC

[OnClick]


Action: Click 'OnClick'

--> (now forms 1 and 3 should open)


Thanks!

 

[apr pillai]

You can use better methods to Open your Forms. It is explained with a simple method and with necessary VBA Code in the following Article:

Opening Access Forms

 

[jabaker54]

Is there a way to do something similar but instead of using forms you are using queries?

 

[jabaker54]

Figured it out... Thanks for the help!