Dim test As Variant test = CurrentDb.OpenRecordset("Query3").OpenRecordset.Fields("User_Logon") If Not test.EOF Then MsgBox "needs to signup" Else MsgBox "signed up user" End If
I’m trying to create a user validation process that when the user opens up the Access it checks if the user is on user table, if so, then they would be redirected to the main form, if not, would be redirected to the signup form.
I’ve tried the code above and every time I run it, I get the popup saying “No current record” which is fine since I want to redirect to the signup form but doesn’t continue with the code but rather gives off a Visual Basic error.
Any suggestions? much appreciated!