pop up placement

[Chrissy]

Can anyone point me to where I can find out how to place
a popup in a set position when opening? The autocenter
property is ok, but I like my user to see a certain field
on the underlying form.

Thanks,
Chrissy

 

[fredg]

Can anyone point me to where I can find out how to place
a popup in a set position when opening? The autocenter
property is ok, but I like my user to see a certain field
on the underlying form.

Thanks,
Chrissy

Set the AutoCenter property to No.

In the load event of the PopUp form
DoCmd.MoveSize , , From Left Position, From Top Position

All measurements are in Twips; 1440 = 1 inch.

See VBA Help.

 

[Stephen Lebans]

In addition to Fred's comments see:
http://www.lebans.com/openform.htm
OpenFormRelativeToControl.zip is an MDB showing how to open a second
Form relative to a control on the parent Form.



Version 1.4

Added logic to handle form's with their Popup property set to True.
Added support for the following positions relative to the specified
control.

' 0 = Underneath
' 1 = On Top
' 2 = Right Side
' 3 = Left Side
' 4 = Bottom Right Hand Corner

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Chrissy]

Thanks to both of you. You are great help.