New form from same form

[Ruegen]

Rather than duplicating a form as another form, is there a way to use VBA to duplicate the current form and then open it without adding another form?




So open another instance of the same form but with some changes...

[Missinglinq]

Allen Browne has a tutorial with a demo database on this subject:

http://allenbrowne.com/ser-35.html

Linq ;0)>

[Ruegen]

Allen Browne has a tutorial with a demo database on this subject:

http://allenbrowne.com/ser-35.html

Linq ;0)>

It's funny - I actually had a quick look at that before today and I wondered if that was what I needed to do the task but I wasn't sure because it seemed like a lot of code just to create a duplicate of what I already have (without actually creating and saving a whole new form - I just want it to "disappear" after it is closed).

[Missinglinq]

The one thing you can always be sure of is that Allen's code is as compact as it can be in order to do the job at hand!

And Allen, like yourself, uses that 'funny' date format, like yourself!

Linq ;0)>