Locking a Form

[baker951]

Im creating a database for a stock contol system. I would like to lock each record in a from once it has been stored but still be able to enter new records without pressing anything. I would then like a command button that a user could press to unlock the record in order for them to edit it in form mode.
I would be grateful of any help
Matt

[nico5038]

I use in such a situation a datasheet subform showing all objects and add Action buttons like [Add], [Update], [Delete], [Print], etc for the dataprocessing.
The actionbuttons will show a new form and the Add form could be made repetitive by having a [Save and Add next] button and a [Save and close] button.
Getting the idea ?

Just check this sample .mdb:
http://www.geocities.com/nico5038/xS...tAction-97.zip

Nic;o)

[ADezii]

Im creating a database for a stock contol system. I would like to lock each record in a from once it has been stored but still be able to enter new records without pressing anything. I would then like a command button that a user could press to unlock the record in order for them to edit it in form mode.
I would be grateful of any help
Matt

Place the following code in the Current() Event of a Form. I'm sure you can figure out the unlock button part from the code also:

Private Sub Form_Current()
If Me.NewRecord Then
  Me.AllowAdditions = True
  Me.AllowDeletions = True
  Me.AllowEdits = True
Else
  Me.AllowAdditions = True
  Me.AllowDeletions = False
  Me.AllowEdits = False
End If
End Sub

[NeoPa]

I just changed the title of the thread to make it easier to find in a search.

[eimbert]

Place the following code in the Current() Event of a Form. I'm sure you can figure out the unlock button part from the code also:

Private Sub Form_Current()
If Me.NewRecord Then
  Me.AllowAdditions = True
  Me.AllowDeletions = True
  Me.AllowEdits = True
Else
  Me.AllowAdditions = True
  Me.AllowDeletions = False
  Me.AllowEdits = False
End If
End Sub

I have a similar problem , Could you pls write the code for unlocking the record so I am able to change data so I can save and update the record.

[eimbert]

I have a similar problem , Could you pls write the code for unlocking the record so I am able to change data so I can save and update the record.

--------------------------------------------------------------------------------

[NeoPa]

I have a similar problem , Could you pls write the code for unlocking the record so I am able to change data so I can save and update the record.

If your problem is similar, then the answer already posted should be more than good enough for you.
This is not your thread to change the question, and we do NOT write code to your specification, we try to lead you to write your own code.

What with the tone of your question, the fact that you're hijacking someone else's thread AND using text-speak in your question (I couldn't even find space to include that you double-posted too), you may want to consider doing this one again from scratch.

MODERATOR.