Enable/Disable Subform 2

[Kjonnnn]

I'm creating a form for Performance Reviews to be used by our HR Department.

Most of the form will apply to every employee ... there is a section that has to do with employees that have supervisory duties and responsibilities.

This is what I've done. I've created a form from a table that has all the things that are common to everyone. I have a another related table that just has things that apply to supervisory personnel. I also have a YES/NO check box to denote whether the current employee is Supervisory or not.

MY QUESTION:

Is there a way that if the above mentioned check box is checked, the things that apply to supervisory personnel will in appear in the main form as a subform and if its not checked, it won't?

 

[Maquis]

Just make the supervisor section visible or invisible based on the value in the checkbox.

Put this code in the on_current section and the checkbox after update events.

If me!checkbox = true then
me!supervisorsubform.visible = true
else
me!supervisorsubform.visible = false
end if
Maq B-)
<insert witty signature here>

 

[Kjonnnn]

ohhhhhhhhhh

thanks

 

[Kjonnnn]

One thing.....

Where exactly do you put those commands?

 

[Kjonnnn]

And what would &quot;ME&quot; be?

 

[jebry]

Hi!

You put the commands in the Form_Current event procedure.

hth Jeff Bridgham
bridgham@purdue.edu

 

[Maquis]

me is the current form and I think I answered your other question in my first post. Maq B-)
<insert witty signature here>