Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 812
  • Last Modified:

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?
Thanks
0
ksilvoso
Asked:
ksilvoso
1 Solution
 
peter57rCommented:
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.


0
 
MikeTooleCommented:
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
0
 
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.
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Tackle projects and never again get stuck behind a technical roadblock.
Join Now