Locopete99
Registered User.
- Local time
- Today, 02:50
- Joined
- Jul 11, 2016
- Messages
- 163
Hi Guys,
On my database I have a login screen. I used to open a form and show all subform results based on what team the users were on. Due to the number of records this is getting a bit slow.
So I'm trying to rebuild using just the operators records.
But, there needs to be the ability to see another team mates details in case they are on holiday or off sick. So i'm trying to do an alternative user logon.
Can you see if you can help with the below? I've had a stab but ot really been one for using unassigned text boxes.
Its currently erroring with 424 "object required" on the opening IF line.
On my database I have a login screen. I used to open a form and show all subform results based on what team the users were on. Due to the number of records this is getting a bit slow.
So I'm trying to rebuild using just the operators records.
But, there needs to be the ability to see another team mates details in case they are on holiday or off sick. So i'm trying to do an alternative user logon.
Can you see if you can help with the below? I've had a stab but ot really been one for using unassigned text boxes.
Code:
Private Sub Form_Load()
If Forms!frm_ISDAltLogin![Text1] Is Null Then
'This checks if the alternate login field has a name in it.
Me.Text0 = fOSUserName
'if not then this puts the current user in the unassigned text0 on this form
Else
Me.Text0 = Forms!frm_ISDAltLogin![Text1]
'if it does it puts this user into the unassigned text box on my form.
End If
End Sub
Its currently erroring with 424 "object required" on the opening IF line.