is there a way to disable a forms vba? or what is the command use to disable a forms vba? thanks.

Hi,

A form's VBA only executes when tied together with an event. So, to disable it, just disconnect it from its event.

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)

hm. no command to stop it? oh well, cause i'm making a user level access on some buttons and since i have them disabled depending on certain changes on the form the disabling them according to user level won't do well as planned.

Hi,

I'm not sure I understand your concern. If the buttons are disabled, then the VBA shouldn't execute. Isn't that what you want?

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)

Yes, you can do that. You'll need some way to tell whether or not the user has "rights" to functions on the form. Then you can place code in the Form's On Load event, possibly other events as well, to examine the user rights value, probably passed in by OpenArgs, other ways are possible, too and disable whichever buttons you don't want that user to use.

If OpenArgs = "End User" Then
Me.NameOfCommandButton.Enabled = False
etc.
Else
Me.NameOfCommandButton.Enabled = True
etc.
EndIf

I have only showed the code for two levels of user, but you can certainly add in more if you wish.