I have a database that users log into using a username and password , then opens own switchboard form.
ElseIf username = "Joe Smith" And password = "JS11" Then
DoCmd.Close
DoCmd.OpenForm "JoeSmith"
My question is I have a command button of their switchboard that opens a form to add project time , is there a way to put code in to add new record and have their name already selected as that record.
I have been able to get a form to open with their name selected but it has record selectors enabled at bottom to view or enter time for other users.
Attachment 15879
I do not want them to be able to use record selectors at bottom to go to next employee but cannot figure out how to hide,disable after opening form , also If I hide the tab page General, the command to filter by name will not work. Any help would be appreciated. I have all my access 2007 books out and have been trying to find solution. Thanks,