Need a read only and an edit mode

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to have the user be in a read only mode when they enter the
form. then give them the ability to switch into an edit mode when they need
to make changes to the data. Is this possible?
 
I would like to have the user be in a read only mode when they enter the
form. then give them the ability to switch into an edit mode when they need
to make changes to the data. Is this possible?
Click to expand...

Sure. Set the AllowEdits property of the form to False in the Form's
Current event (to reset it to False for each existing record), and to
Yes in a command button's Click event. Clearly you should allow the
new record to be editable...

Private Sub Form_Current()
Me.AllowEdits = Me.NewRecord
End Sub

Private Sub cmdOpenForEdit_Click()
Me.AllowEdits = True
End Sub

John W. Vinson[MVP]
 
John
Thank you! I was able to set up the edit function.

One more question: I have a drop down list of all the subject IDs on the
form in order to 'go directly' to a record. It currently works in edit mode,
Can I make it function in the browse mode too?

Juliann
 
Back
Top