Locking txt field after saved

[avenger619]

Hi guys,

I was wondering what would be the best way to automatically lock a txt field after data entry and only after form has been closed or moved to a new record and saved.

for example my key field for all my forms, quaries goes by "Applicant" I would like to lock this so users cant tamper with the name afterwards its been saved.

but nevertheless, would like to have the ability to unlocked if a correction needs to be made, or would corrections be made manually on the table directly?

 

[John Big Booty]

Try the following in your Forms' On Current event;

Me.YourFieldName.Locked = Not Me.[URL="http://office.microsoft.com/en-au/access-help/newrecord-property-HA001232762.aspx"]NewRecord[/URL]

 

[Pat Hartman]

In addition to the locking code, you'll need code in the click event of a button to unlock the field.
Me.YourFieldName.Locked = False

 

[avenger619]

RESOLVED>
Pat and John thanks soooo much this combination works magnificently!

 

[NightSpy2]

Hi, I've tried this code but I'm trying to make it so that one button is for Locking the data, and the other is for Unlocking it.

But when I try to click my Lock or Unlock button, it says 'Invalid Qualifier'. Any help?
My code for the button is:

Private Sub Lock_Click()

Me.Name.Locked = Not Me.NewRecord
etc

End Sub

Private Sub Unlock_Click()
Me.Name.Locked = False
etc

End Sub

 

[John Big Booty]

Try;

Private Sub Lock_Click()

Me.Name.Locked = [B][COLOR="Magenta"]True[/COLOR][/B]
etc

End Sub

Private Sub Unlock_Click()
Me.Name.Locked = False
etc

End Sub

 

[NightSpy2]

Hmm tried that and got the same thing


Annoying..
After I click OK it also highlights the

Private Sub Lock_Click()

in yellow.

Is it something to do with my naming of 'Name'? Since it's selected?

 

[John Big Booty]

Don't know why i didn't notice before but Name is a reserved word :banghead:

Change the field name or enclose it in square brackets;

Me.[B][COLOR="Red"][[/COLOR][/B]Name[B][COLOR="Red"]][/COLOR][/B].Locked = True

 

[NightSpy2]

Yay that worked! Thank you so much!

Any chance you could help me with my other problem? I posted a thread on it but I got no replies