Remove option after chosen on form

[HansBades]

I have a form where the user can designate the PM for a project. But once they choose the PM and click the submit button, I want that option to no longer be available. In other words, they can no longer change PM's once one is chosen, at least not from their access rights. I have code that sets the object's visible property to false after they select a PM. But when you close and reopen the form the object reappears. How can I make this so it can only be used once and then it disappears as an option for the users permanently? Thanks.

[CJ_London]

no idea without know how your form works but best guess is you need some code in the current event to hide the control if a PM has already been selected

[Welshgasman]

Wouldn't be better to just lock it?

[Gicu]

Maybe something like this in the Current event of the form (assumes the PM control is a combo box used to select the PM value):

Me.cboPM.Visible=IsNull(Me.cboPM)

Cheers,

[HansBades]

That worked great. Thank you Gicu. I couldn't lock it for some other design reasons. But using the current event of the form did what I needed. Thank you all.