alvingenius
IT Specialist
- Local time
- Tomorrow, 00:40
- Joined
- Jul 10, 2016
- Messages
- 169
there is a code for it. better to put the code in the Load event of the nav form,
becoz right's of each user will likely not change, so using current event you always enable/disable the control.
Code:Dim bolJumped as Boolean If txtaccesstab1= False Then ' from dlookup Forms!frmMain!Nav1.Enabled = False Else Forms!frmMain!Nav1.Enabled = True If bolJumped = False Then bolJumpted = True Forms!frmMain!Nav1.Setfocus Sendkeys "{ENTER}" End If End If If txtaccesstab2= False Then ' from dlookup Forms!frmMain!Nav2.Enabled = False Else Forms!frmMain!Nav2.Enabled = True If bolJumped = False Then bolJumpted = True Forms!frmMain!Nav2.Setfocus Sendkeys "{ENTER} End If End If If txtaccesstab3= False Then ' from dlookup Forms!frmMain!Nav3.Enabled = False Else Forms!frmMain!Nav3.Enabled = True If bolJumped = False Then bolJumpted = True Forms!frmMain!Nav3.Setfocus Sendkeys "{ENTER}" End If End If
Well, that's worked like charm
Thanks alot @arnelgp and thanks to @theDBguy