Correct syntax for passing controls as arguments 1

[Maquis]

Can someone please help me figure out the correct syntax for this module. I've been struggling with it for the past hour an it's about to drive me crazy.

I have the following Subroutine defined in my form...

Private Sub ControlDisable(ctl As TextBox)
    ctl.Locked = True
    ctl.Enabled = False
    ctl.SpecialEffect = 0   'flat
    ctl.BackStyle = 0       'transparent
    ctl.BorderStyle = 0     'transparent
End Sub

And I'm calling it from another subroutine in the same form like so..
ControlDisable (Me.Controls("AdjName&quot)

However, I keep receiving an error 424 "Object required".
AdjName is the name of a textbox on this form, so I know that isn't the problem.

Any ideas?

Maq
<insert witty signature here>

 

[FancyPrairie]

Try calling it like this:

ControlDisable (AdjName)

or like this

ControlDisable (Me!AdjName)

 

[Maquis]

Nope, I still get the same error. Actually, I had that syntax in there first, but later changed it to the me.controls() format.

Now, you see why I'm frustrated!

Maq
<insert witty signature here>

 

[FancyPrairie]

I think I know what your problem is. It's how you are calling the sub. The syntax should be either

Call ControlDisable(AdjName)

or

ControlDisable AdjName

But not

ControlDisable (AdjName) 'Note the parenthesis

 

[Maquis]

Yayy! That did it.

Sorry, I should have seen that. Those parentheses trip me up everytime.

Ok, now onto the 50 other problems my boss wants me to solve today.

Is it Friday yet?

Maq
<insert witty signature here>