Hi,
I have a table called tbl_Admin, this has 2 fields in it that identify the users of my database, these are "Loginname" & "userpermissions". I am looking for a way to enable and disable certain textboxes on a form depending on the criteria in the userpermissions field.
The db opens on a form called Home, this has an unbound textbox that captures the environ("username"). Is there a way the username i capture in the textbox can look up the "loginname" in tbl_Admin and then look at the "userpermissions" associated to it ?
I did try and look at DLookups but just didn't get anywhere at all
thanks miff3436
I have a table called tbl_Admin, this has 2 fields in it that identify the users of my database, these are "Loginname" & "userpermissions". I am looking for a way to enable and disable certain textboxes on a form depending on the criteria in the userpermissions field.
The db opens on a form called Home, this has an unbound textbox that captures the environ("username"). Is there a way the username i capture in the textbox can look up the "loginname" in tbl_Admin and then look at the "userpermissions" associated to it ?
I did try and look at DLookups but just didn't get anywhere at all
thanks miff3436