Unlock a text field if a new record is added

  • Thread starter Thread starter kgeary1
  • Start date Start date
K

kgeary1

I am looking for a way to unlock a text field as new record is added.
I have a cmd button set up to enter a new record. I know that I can
place the code on the click of the cmd button. I also want to hide
the toolbar and the menu as the form is opened.

I would appeciate any help with this.

Thanks,

KGeary
 
I am looking for a way to unlock a text field as new record is added.
I have a cmd button set up to enter a new record. I know that I can
place the code on the click of the cmd button. I also want to hide
the toolbar and the menu as the form is opened.
Click to expand...


To lock/unlock a control depending on the new rcord, use the
form's Current event:
Me.textfield.Lock = Not Me.NewRecord

You can hide/show menu/toolbars using variations of this in
the form's Open/Close events:
DoCmd.ShowToolbar "Menu Bar", acToolbarYes
 
Back
Top