locking the contents when viewing

[saleemMSMS]

hi
how can i lock the fields in a form when viewing contents but to unlock them when adding a new record ?? is it possible if yes, how ?

 

[John Big Booty]

Yes you can. You can set the form's Allow Edits property to No this will prevent the editing of existing records but allow the addition of new records.

 

[HiTechCoach]

Try:

Private Sub Form_Current()

  Me.AllowEdits = Me.NewRecord

End Sub

 

[saleemMSMS]

hey thank you very much HiTechCoah !! you are a real problem solver !!
also thanx John Big Booty for the quick response.. ;-)

hey theres another problem. say if i include a button in the form saying "edit" which will make the current record editable, then what code should i write in the button click event ?

 

[saleemMSMS]

hey i think i got it..
its
Me.AllowEdits = True
right ?

 

[John Big Booty]

Me.AllowEdits = True

Will allow existing records to be edited and new records to be added. Whilst;

Me.AllowEdits = False

Will prevent existing records being edited whilst you will still be able to add new records.