Open an Access sub form and "anchor" it physically to one field for appearance

How can I open an Access subform from its parent form and have the subform open as a small box that is anchored to one field of the main form?
Who is Participating?
peter57rConnect With a Mentor Commented:
You can set a form's size and position using the Docmd.Movesize command in the form open event procedure (see Help for the parameter settings).
What you are describing would not generally be thought of as a subform, just as another form.

Have the main form control the subform's visibility.
Move the subform to the mainform control's position just before you make it visible by adjusting the Top, Left properties of the subform control
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Note also that you'd need to do this in the Resize event of your form, using the methods described by Peter or Mike.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.