2 form for the same table.

[Leslie]

I have a table that I can change the information on 2
forms.
What do I have to do in order the computer should stop the
connection from the first form, once I go to the 2nd form?
I don't want to close the first form.
In other words, when I click the button that opens the 2nd
form, I want the computer to save all information from the
first from, and the same when I go back to the first form.

I have created both forms with the built-in Form Wizard.

Thanks

Leslie

 

[John Vinson]

What do I have to do in order the computer should stop the
connection from the first form, once I go to the 2nd form?
I don't want to close the first form.
In other words, when I click the button that opens the 2nd
form, I want the computer to save all information from the
first from, and the same when I go back to the first form.

The first question is... why two forms for one table!? It's an added
level of complexity. Might you consider a Tab Control on the form, if
the problem is screen real estate?

That said, you can put a line in the VBA code which opens the other
form:

DoCmd.RunCommand acCmdSaveRecord

to write the current record to disk. You should also move off the
record, otherwise the second form will generate an error when you try
to edit the record - since it's already being edited on the other
form.

 

[Dr. Stefan Schneider]

I have a table that I can change the information on 2
forms.
What do I have to do in order the computer should stop the
connection from the first form, once I go to the 2nd form?
I don't want to close the first form.
In other words, when I click the button that opens the 2nd
form, I want the computer to save all information from the
first from, and the same when I go back to the first form.

I have created both forms with the built-in Form Wizard.

Thanks

Leslie

Okay