Hello,
I have a form 'CLIENT_CALL_INFO' that has 20 text boxes on it with client information populated from my table 'tblCLIENTINFO'. It is accessed through a form 'CLIENT_LOOKUP'. I need to lock the 20 text boxes for most users but allow edits for 6 users. The users may change occasionally so I wanted to make a 'USER_ID' table for quick changes down the road.
I want to set allowedits on the form to no and then use the fosusername module linked to a 'USER_ID' table to allow edits to all the text boxes on the form. I'm still a beginner with VB and have no idea where to start on this.
Any help would be appreciated. Thank you.
I have a form 'CLIENT_CALL_INFO' that has 20 text boxes on it with client information populated from my table 'tblCLIENTINFO'. It is accessed through a form 'CLIENT_LOOKUP'. I need to lock the 20 text boxes for most users but allow edits for 6 users. The users may change occasionally so I wanted to make a 'USER_ID' table for quick changes down the road.
I want to set allowedits on the form to no and then use the fosusername module linked to a 'USER_ID' table to allow edits to all the text boxes on the form. I'm still a beginner with VB and have no idea where to start on this.
Any help would be appreciated. Thank you.