Enable Conditionally

[naungsai]

Dear friends

I have a form with a sub-form in my front end database.
In the form I have a field which notes the Person who enter the form.
Another field I have is Person who is logging in.

Question: if the person who created the record is equal to the Person who is logging in, the fields in both form and sub-form are enable. It means she can edit the current record in form and subform.

If not, all the fields are disabled.

I also have 2 buttons which are to print the records. These 2 button are enable in both conditions.

May I get the problem solved by VBA?

Thanks in advance.

Sai

 

[naungsai]

Thank you for your prompt response.
It work well.
Thanks again.

Best