Using an object in a Sub cmd_Enter_Click(frm_Name As Object)

[111StepsAhead]

I am not sure how to refer to an Object in my sub

Please Login or Register  to view this content.

Normally if I didn't need to use the object when I clicked enter I'd call my form by

Please Login or Register  to view this content.

However if I leave out the frm_Name As Object I get the error 'Argument Not Optional' when I use the frm_Name in cmd_Enter_Click.

So my question is what do I need to do to use an Object in the Sub cmd_Enter_Click()?

As always thanks for helping me.

EDIT: FOR CLARITY, VBA won't take the parameter but I need a parameter or I can't use the object.

[Mordred]

Hi 111StepsAhead try this at the beginning of your sub:

Please Login or Register  to view this content.

[111StepsAhead]

I get the compiler error "Procedure declaration does not match description of event or procedure having the same name."

I am not very familiar with passing by Reference in VBA. Any other suggestions here?

[shg]

Is this the click event for a button on a form? If so, it doesn't take any arguments.

[111StepsAhead]

Yes, it is a click event for a button on a form. If it is true that it doesn't take any arguments then do I need two forms in this case?

[romperstomper]

I don't understand why you can't just refer to the object the way you normally would.

[111StepsAhead]

Hold up! How would I normally refer to the object?

My issue is I have two processes that do the same thing. They both call a first form to select the mode. Based on what process is used a different user form will be called after the mode is chosen.

i.e. I have 3 modes. If I pick mode 1 certain options will appear but because either process might have been chosen I need frm_Name.

I will get back to this in a bit. Taking a short break.

[shg]

You can't change the signature of event handlers, and as Romper says, there's no need to.

[romperstomper]

Depending on flow:
If the first form calls the second, then pass a variable from the calling procedure so ti knows what to load.
If the calling procedure calls the second object after the mode is chosen (possibly better) then the first procedure can determine what to load.