Locked records (1 Viewer)

[kitty77]

I have a form that all records are locked. On the form, I have a button that unlocks the records. I also have several other buttons (save, refresh) on the form.
I would like when someone clicks the save button and the records are locked "say records are locked"

Thanks...

 

[theDBguy]

So, in the Click event of the Save button, do something like:

If Records Are Locked Then MsgBox "Records are locked!"

How do you lock the records or how do you check if they are?

 

[kitty77]

Records are locked on Current and a text is visible if locked and not if unlocked.

 

[theDBguy]

Records are locked on Current and a text is visible if locked and not if unlocked.

Okay, you can either use the same code or check for the visibility of the text. For example:

If TextboxName.Visible Then MsgBox "Record is locked!"

Hope that helps...

 

[kitty77]

Perfect!!!

 

[theDBguy]

Perfect!!!

Hi. Glad to hear you got it to work. Good luck with your project.