Passing WindowLeft/Top values in openargs to position popup

[Mr. Smith]

Hi.
I have two popup forms. On the first popup form I have several buttons where
I want the onClick to open a new popup form right below the button.

I'm trying to build the "expand" feeling, as the second popup form is
without borders and "feels" like a subset to the first poput.

How can I use the position value from the button clicked to set the position
to the second popup?

Trying to user "openargs: WindowTop & | & WindowLeft" calling the secound
popup, but I get values like -12365 which is not good when using
DoCmd.MoveSize while opening the second popup....

Also WindowTop/Left refere to the first popup form, and not the actual
button......

Any hints appreciated!

Kind regards
Mr. Smith

 

[Stuart McCall]

Hi.
I have two popup forms. On the first popup form I have several buttons
where I want the onClick to open a new popup form right below the button.

I'm trying to build the "expand" feeling, as the second popup form is
without borders and "feels" like a subset to the first poput.

How can I use the position value from the button clicked to set the
position to the second popup?

Trying to user "openargs: WindowTop & | & WindowLeft" calling the secound
popup, but I get values like -12365 which is not good when using
DoCmd.MoveSize while opening the second popup....

Also WindowTop/Left refere to the first popup form, and not the actual
button......

Any hints appreciated!

Kind regards
Mr. Smith

Not as easy as you might expect, given the way Access forms are constructed.
Here's my version of 'popunder' code:

http://www.smccall.demon.co.uk/Forms.htm#OpenUnder

This has been tested in Access 2000 and 2003.

Good luck.

 

[Mr. Smith]

Thanks Stuart for sharing your code!

I'll dig into it during the weekend.

Kind regars.
Mr. Smith

 

[Marshall Barton]

I have two popup forms. On the first popup form I have several buttons where
I want the onClick to open a new popup form right below the button.

I'm trying to build the "expand" feeling, as the second popup form is
without borders and "feels" like a subset to the first poput.

How can I use the position value from the button clicked to set the position
to the second popup?

Trying to user "openargs: WindowTop & | & WindowLeft" calling the secound
popup, but I get values like -12365 which is not good when using
DoCmd.MoveSize while opening the second popup....

Also WindowTop/Left refere to the first popup form, and not the actual
button......

Are you sure that you need a second, independent form to do
that? My first reaction is to use one form with the
"expand" part in the form footer section. The button would
simply make the form taller (using the InsideHeight
property) and make the footer section visible. If your
proposed two popup forms are bound to different tables, then
use your second popup as a subform in the first popuup's
footer.