Open subform based on checkbox

G

Guest

Is it possible to open a subform (or direct data to another form) based upon
a checkbox being checked?

I have three tables I am using atm: Manager, Supervisor, Review (main, sub
and additional sub/other form)

I have my relationships set up from manager to supervisor just fine. I
would like to be able to display all sups assigned to a manager each with a
checkbox next to them so that I can simply check each one who took the
course. I would like the course ID [courseid] to be entered into the
supervisor's table at this point. Can you help please?
 
G

Guest

Hi Angel,

Put a Option Group and place the required no of check boxes in the form
which contains all the details, such as Managers, Supervisors, Review etc.,.
When you place the Option Group button onto the form, there will be a wizard
populated. Follow the instructions. Name the option Group as Managerslist.
Name the check boxes, as to your Managers Name. You can have all the other
details, listed in this form itself, like the Supervisor , Review etc.,

Create a Macro in the Macro new.
Name the macro as Managerfilter. ( If the Condition and the Action column is
not visible on the Macro, place it by pressing the icons . These icons will
be next to undo and redo command.)
Condition - Managerlist = 1
Action = Applyfilter. Give the condition in the where column at the bottom.
For eg.,
Where = [Manager] like "TOM"

and so on as to how many managers you have. Save the Macro as Managerfilter.

Now open the form., where, you have placed the Option Group. In the
Properties of the Option Group which is named as Managerlist, set the
Afterupdate event to Managerfilter.Managerfilter. Or use the drill down list
which will be shown against the Afterupdate event.

Please let know, whether this was useful.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top