Opening a second instance of a single form

[Danick]

I have a continuous form showing a set of records. There is DoubleClick event on the record number, which will open a single form for that particular record. When you close that single form, the continuous form is shown again – all is good.

In the single form, there is a field that users can use for related records. If you double click that field, the single form now displays the record number that was in that related records field.

What I would like to do is have another instance of this single form open while keeping the original single form stacked behind. So when the user closes this instance of the form, the previously shown record can be seen again.

Is this possible and if so, are there any examples of how to do that?

 

[theDBguy]

Sure. Check this out. Hope it helps...

 

[Danick]

Sure. Check this out. Hope it helps...

Thanks - that was fast.

This seems to be what I'm looking to do, but there are no sample databases that actually shows it in action. I can crate a small one for testing, but it would be great if there was one readily available. I'm using access 2010.

 

[theDBguy]

Thanks - that was fast.

This seems to be what I'm looking to do, but there are no sample databases that actually shows it in action. I can crate a small one for testing, but it would be great if there was one readily available. I'm using access 2010.

Hi. I would have to Google around to find a sample for you. It might be faster if you create a small sample and try the code from the website. If it doesn't work, you can post the db here, so we can check it.

 

[isladogs]

Try looking at these threads https://www.access-programmers.co.uk/forums/showthread.php?t=299840&highlight=instance+form&page=2 and https://www.access-programmers.co.uk/forums/showthread.php?t=300844&highlight=instance+form

If I recall correctly, MarkK had a very effective solution

 

[Gasman]

Links to the sample databases are at the bottom of the page of that article?
I've just downloaded the Access 2000 version and it woks fine?

Thanks - that was fast.

This seems to be what I'm looking to do, but there are no sample databases that actually shows it in action. I can crate a small one for testing, but it would be great if there was one readily available. I'm using access 2010.

 

[Danick]

Links to the sample databases are at the bottom of the page of that article
I've just downloaded the Access 2000 version and it woks fine

Thanks - I didn't notice the sample database links at the bottom of that article. Looks a little complicated for what it ultimately does, but at least I can see that it can be done. I'll have to set aside some time when it's not too busy to try and adapt the method.

Thanks again and have a great day!!

 

[theDBguy]

Thanks - I didn't notice the sample database links at the bottom of that article. Looks a little complicated for what it ultimately does, but at least I can see that it can be done. I'll have to set aside some time when it's not too busy to try and adapt the method.

Thanks again and have a great day!!

Hi. I haven't read the article in a while, so I forgot about the sample database as well. Good luck and let us know how it goes.