How can I get the details of a form to display when a user logs in?
For instance, I have a RegularUser form that the admin uses to make the user (LoginName, Password) and then once the user logs in, they should be able to fill out their details firstly (NewEmployee form, set to Create) then edit them at any point (EmployeeDetails form, set to Edit)
BUT when the employee logs in and clicks Edit Details, it brings up the blank form again and you have to resubmit the entire form. What is the best way to show the forms details?
I tried a query that displayed the staff members but it showed the other staff members as well, and even though I made their details uneditable, its not the best idea to have their personal details visible to everyone.
So I guess, just a query that shows the current logged in staff member would be great but I can't get it to work.