Hello,
i have 3 tables
(tblUser)
(tblDepartment)
(tblfrm)
On my main form (frm1) is a combo box (cbo1) and a text box (txt1).
the txt1 is hidden and displayers the current users computer login.
I'm trying to achieve a verification process so if a users name in txt1 is in the same department cbo1 is registered too, it will allow that user to alter a second text box (txt2)
My user table is the following
UserID | UserName | UserCode | Department |
1 | Jake F | FosJak | 1 |
The user code is manually input when a user is created to give a value to compare against for the txt1.
This is an example statement obviously not in the correct coding.
on change of cbo1 lookup txt1 (FosJak) and compare to user table, if the user that has matching UserCode (FosJak) has department value of 1 then allow txt2 to be enabled.
Hopefully this makes sense?
i have 3 tables
(tblUser)
(tblDepartment)
(tblfrm)
On my main form (frm1) is a combo box (cbo1) and a text box (txt1).
the txt1 is hidden and displayers the current users computer login.
Private Sub Form_Current()
Me.txt1 = Environ("USERNAME")
End Sub
I'm trying to achieve a verification process so if a users name in txt1 is in the same department cbo1 is registered too, it will allow that user to alter a second text box (txt2)
My user table is the following
UserID | UserName | UserCode | Department |
1 | Jake F | FosJak | 1 |
The user code is manually input when a user is created to give a value to compare against for the txt1.
This is an example statement obviously not in the correct coding.
on change of cbo1 lookup txt1 (FosJak) and compare to user table, if the user that has matching UserCode (FosJak) has department value of 1 then allow txt2 to be enabled.
Hopefully this makes sense?