TheSafetyGuy86
Registered User.
- Local time
- Today, 11:00
- Joined
- Jun 18, 2013
- Messages
- 31
Good Morning Forums,
I am working on an log in form that has a text box and a password box, both unbound. I am trying to set it up so that when a user types in their name, it searches for their record and compares the entered password against their actual password inside the database. I am having trouble getting the username textbox to update the current record. I am using a macro in the After Update field for the username textbox.
="[User] = " & Nz([Screen].[ActiveControl],0)
It does not return the selected record, but if I change the username to a combo box, it updates the record just fine. I don't want a combo box though because I don't want to list usernames to anyone that enters the database.
Any ideas?
Safety Guy
I am working on an log in form that has a text box and a password box, both unbound. I am trying to set it up so that when a user types in their name, it searches for their record and compares the entered password against their actual password inside the database. I am having trouble getting the username textbox to update the current record. I am using a macro in the After Update field for the username textbox.
="[User] = " & Nz([Screen].[ActiveControl],0)
It does not return the selected record, but if I change the username to a combo box, it updates the record just fine. I don't want a combo box though because I don't want to list usernames to anyone that enters the database.
Any ideas?
Safety Guy