Record Locking after the edition, access 2010

[Mobile]

Hi, I am new to Access and need a little help.

I am trying to lock a single record of a form, after all the members edited the form so nobody can come back to the record and edit after that. But I don't want to lock the database.

Once the form manager clicks the submit button, the first record of the form should lock and then move on to the second record for a new project. I found a couple of codes online but I get error message when I click "Run". Also I'm not sure if I'm connecting the code to the Form right.

Your help will be very much appreciated!!


This is the Code example from the old post I was using:

Private Sub Command357_Click()
If Me.NewRecord Or IsNull(Me.DateCompleted) Then


Me.AllowEdits = True

'' if there is a sub form(s) use the following
Me.SubFormName.Locked = False

Else


Me.AllowEdits = False
'' if there is a sub form(s) use the following
Me.SubFormName.Locked = True


End If

End Sub

[June7]

The AllowEdits is attempting to set the mode of the form, not record. Is the form in Single record view?

What is the exact error message?

Is the subform actually named 'SubFormName'? Use your subform name.

[Mobile]

I want to use one record of the form per a project (project 1 for record1, project 2 is record2). I want to be able to lock each record when the project information is complete.

I'm not sure what you mean by sub-form. Should I just take off this part?

[Mobile]

I just found an old thread
"i have created a payroll using access 2007. is there an option to lock only one specific record rather than the whole table.
For example, if John is no longer an employee i want to lock it and never be able to unlock it again."
https://www.accessforums.net/program...ord-11398.html

Seems like the only option is to move a single record to the archive table.....

[June7]

Actually, the best practice is to filter the form RecordSource so undesired records are not displayed. What criteria could be used to filter? Is there a 'Termination Date' field? 'Moving' records is not advised.

[Mobile]

June 7,
Thank you for your response. I have no idea how to filter the form RecordSource... I will start researching.
If you know any good thread for leaning how to Filter the form RecordSource, please let me know.
I appreciate your help, thank you!

[June7]

For two methods, review:

https://www.accessforums.net/forms/s...red-35570.html

http://datapigtechnologies.com/flash...tomfilter.html

[Mobile]

Thank you June 7. I will try that!