compare results

[Casmurbax]

good day,

I am very new to this and would really appreciate any help I can get.
I have searched this forum for answers and I am sure it is here, but I guess I am not searching using the correct phrase or I can not interrpert the the findings to what I am trying to do.

What I would like is the following:

allow access to the form by their userid
i have a table with the userids
module where it gets the current username of the person logged into the PC

I have a query that list the userids and criteria fOSUserName()

I want to be able to check to see if the user that is signed on and is in the table of the userids. if so then open up the form and allow them to edit the form.

if no, then do not open the form and display a message that they do not have permissioon.

I imagine I want this [Event Procedure] put in on open in the form. I am not getting it to work for nothing.


thank you in advance for any help

 

[Krava]

Hi, Casmurbax!

I am not sure if I undrstood correctly, but I have changed your code in Form1.
Have a look if it is suitable for you.

Regards

Krava

 

[Casmurbax]

works perfectly
thank you very much for your help.