Reply to thread

Message: [QUOTE="Esther, post: 11970090"] I want to open multiple instances of the same form and name the tabs in Access 2007 and I'm having trouble. I have a continuous form (form1) that lists the employees in a table. The command button beside each employee takes their id number and opens form2 with their employee data. The users want to go back to form1 and select another employee, leaving form2 open for employee1 and showing their last name on the tab and open form2 for employee2 with their last name on the tab so they can work between the two employees. I have written a procedure that accomplishes the goal of a named tab for one employee. There are two questions: 1. When I exit the database and pull up the form (just by itself, not using the form), it continues to hold the employee name from the last time the form was opened. 2. How to I open multiple instances of the form? I've tried the New keyword in both the "Set" and "Dim" and neither have worked. Here is my on-load procedure when form2 opens: Private Sub Form_Load() Dim frm As Form DoCmd.OpenForm "Employee" Set frm = Forms!Employee Form_Employee.Visible = True Form_Employee.Caption = Me.EMP_LastName End Sub Thanks in advance! Esther [/QUOTE]