Get current form name from vba

[psbsmms]

I need to retrieve the current form name programically so I can ge it into a variable. Any Suggestions?

 

[CautionMP]

Screen.ActiveForm.Name

 

[psemianonymous]

Me.Form returns the form name where the code is being executed (i.e. Form_Current() or some other subroutine), so it may/can differ from the above at times.

 

[psbsmms]

Thanks screen.activeform.name gotme just what I needed. Me.form returned multiple properties of the form, which will more than likely come in handy later. Thanks to both for all your help and quick response.

 

[psemianonymous]

Ack, I mean Me.Name, my synapses are firing blanks today apparently.

Me. is the same as Me.Form.

Or maybe you shouldn't believe what I say today--probably for the best.

 

[psbsmms]

Any code comes in handy at some time. I can't the number of times I miss tyed something only to try and recreate it again when I need it. I appreciate the time and effort.