Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Opening more than one copy of the same form

Status
Not open for further replies.

8441

Technical User
May 9, 2001
54
GB
I have an application which enters incident details. This is referenced by a unique autonumber. What I need to do is to be able to open the Incident_Details form to enter the details but have the ability to open the same form to enter another incident while the previous incident is still open, therefore having the same form open twice with different unique refernece numbers?
 
You need to create two identical forms.

B-) ljprodev@yahoo.com
ProDev
MS Access Applications
 
Assuming the form is called frmIncident_Details: The command button that calls the form needs to have this code to create a new version of the object

in the general declarations of the frmIncident_Details place this code Dim frm as Form


Then create a new command button on the form to kick off the new form:
Private Sub myCmd_Click()
set frm = new Form_frmIncident_Details
frm.setfocus

end sub

some things to think about:

1. The new versions of the form hold their information in temporary memory - so you may have to use ADO or DAO to save information to the database. Only the original form is saved permanently to the database

2. To kick of third version of the form, the second version's cmdbutton must be clicked. Using the original form's cmdbutton deletes all of the multiples and then creates a new multiple.

3. Closing the original form will close all of the multiples that have been created

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top