Quick Script question about Form buttons

[owuraku]

I have a database with a login interface. The login works by reading off information off of a table with a list of users. On this table I have field called USER_ACCESS_LEVEL which denotes which user belong to the group ADMINS or USERS. Within the database, I also have a form with several buttons on it. Now depending on the group a user belongs to I want that user to have some buttons activated and the remaining button disabled. For the sake of simplicity let's assume that I have 2 users, USER_1 and USER_2. USER_1 belongs to the ADMINS group and USER_2 is a member of the USERS group. Let's assume further that the form with just 2 buttons, BUTTON_1 and BUTTON_2. When USER_1 logs in, BUTTON_1 should activate while BUTTON_2 becomes disabled. The opposite happens when USER_2 logs in.

[Stewart Ross]

Hi. You can enable or disable the buttons on your form in the On Load event handler of the form itself. You would need to test the user access level, and I do not know how you do that in your case. Assuming that a direct test is possible, the following code in On Load should give you ideas to check out:

Dim AdminUser as Boolean
AdminUser = (user_access_level = "ADMINS") ' - substitute whatever is correct in your own case
Me!Button1.enabled = AdminUser
Me!Button2.enabled = Not AdminUser

-Stewart