Visible combo boxes set to NO

[ptrifile]

I have quite a few Combo boxes on a form that are set VISIBLE:NO. I have code that changes them to be visible if a certain choice from another combo box is chosen

here is an example of one:

Private Sub CallType_Change()
If CallType.Value = "Other" Then Notes.Visible = True Else Notes.Visible = False
end sub

Everything works fine until going to a new record, the fields that are set to be VISIBLE:NO still show on the form. Is there code that i can add so that the form refreshes and the text or combo boxes go back to there set state of not being visible?

Thanks for any help

Paul

 

[PHV]

In the Current event procedure of the form:

Me!Notes.Visible = (Me![CallType] = "Other")
...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[missinglinq]

Or if you don't like PHV's shortcut, simply place your own code in the Form_Current event.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[SeeThru]

Or even add

CallType_Change

to the Form_Current - that way if you add more combo boxes you do not have to repeat the code.

SeeThru
Synergy Connections Ltd - Telemarketing Services