Edit Data on another form

M

Mail Merge Help

Hi

I have a form with data, but I dont' want user to edit on this form, I have
created a button for user to click on to open another form for editing.

My Question is what code should I use on this button so when the user click
on the it, a message pop up asked "do you want to edit current record
only?", if user click No, then a form pop up with all the records related to
the same refID for editing, if the user click Yes, then this form will only
display the current record for edit.

Also another it's might encounter is that if I already have the current
record open on the previous form, by click on the button to edit that records
only, the database will not allow. how to disable the current record on the
previous form so that user can edit on the editing form.

And when the user close the edit form, it will open back the previous form
for viewing the changes?

Many thanks for any help.
 
Top