How to unhide a button when the form is opened based on certain criteria

[shandoo27]

how to make a command button in a form visible automatically when the form is opened if he is in admin mode ?

 

[jdraw]

how to make a command button in a form visible automatically when the form is opened if he is in admin mode ?

Approach with air code

If (conditions met) then
me.button.visible = true
else
me.button = false
end if

 

[shandoo27]

Yeah I agree. But sorry, since I am new to VBA programming in MS access , could you tell me where this code should be written. I am only used to writing VBA codes for click function of command button. I dunno how to make something happen when the form is opened. Please guide me with this issue.

Thanks in advance for the help

 

[dbDamo]

Place the code in the On Open event of the form