E
Esther
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
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