Not identical 2nd instance of a form

  • Thread starter Thread starter Annelie
  • Start date Start date
A

Annelie

I have a main form which comes from the employee table, with a subform to
enter the current week's hours. When there is a problem with an employee, I
want to open the employee table form to be able to access all the employee
information and make changes or additions if necessary, but I am always
required to closed the first form in order to do that. I tried Allen
Browne's example as well as one from Microsoft and it did not work. I think
that is because I really am not opening the same form twice, I am opening
the same table.
Any ideas?
Annelie
 
Hi Annelie,

How about adding a command button to both forms? Each button closes the
current form and opens the other form using DoCmd.Openform You can use the
record ID of the current record to open that same record in the other form.

HTH
 
I create a command button using the wizard for close form at:
DoCmd.Close
I added this second line
DoCmd.OpenForm "frmEmployeelist"

I still get the error message the employee list is already in use.
Annelie
 
Back
Top