User permission field

[dand_dd]

Hi,

I have a login form with users and password and another form with some textboxes. My problem is that I want to make user field permissions.

For example when I choose an user and type the pass and then I click on GO button I go into the another form, and I want for users dan1, dan4 (are admin) just only a1, a2, a3 text fields are active, user cam make changes, the other 2 a4, a5, are visible but user cannot write nothing, but he see the text from text field. For the other 2 user dan2, dan3, are just a4, a5 active the other 3 are visible and inactive.




Thanks.

Dan

[ben.oates]

Sorry, I can't download the database at work, but I would put an identifying field on the user relation so that you know from that who is an admin etc. then run code in the afterUpdate or onLoad event for the form that sets the Enabled property of each text box to True/False appropriately.