How to temporary lock form for editing

[aonsu209]

Dear all,
I need advice what is the best way to lock form for editing. In the database that Im building I want to restrict editing form for certain time.Below you can see scheme of how the database is build. How you can see from the scheme the red circle is where I want to temporarily disable the relationship. Im thinking for event when you open the admin form for checking to restrict employees form or some time event.
What you will suggest me and how?

[pbaldy]

You could certainly do something like:

If SomeConditionIsMet Then
  DoCmd.OpenForm...
Else
  MsgBox "You can't open that form because..."
End If

I'm not really clear on what your condition is though.

[aonsu209]

You could certainly do something like:

If SomeConditionIsMet Then
  DoCmd.OpenForm...
Else
  MsgBox "You can't open that form because..."
End If

I'm not really clear on what your condition is though.

Something like that, but not only a message but also a restriction of the form itself. is it possible something like that

If Me.ControlName > "" Then
Me.Form.Enabled = False
Else
Me.Form.Enabled = True
End If

And the controlname can be check box which Admin can check after open her form with command "check all".
Thanks

[Missinglinq]

Forms don't have the Enabled Property. You can use

Me.AllowEdits = False

Linq ;0)>

[aonsu209]

Perfect this is what I've looking for.
Thank you!

[Missinglinq]

Glad we could help!

Good luck with your project!

Linq ;0)>