Move a form to particular position when opened from another form

Posted on 2012-08-28
Last Modified: 2012-08-28
I have a form that calls another form and I need that second form to open in a partiuclar position in the Windows screen. I  know it can be done, but what  have does not work.  This is an ACCESS 2003 database.

   DoCmd.OpenForm "frmClaimsParent", acNormal, , "ClaimNumber = '" & Me.ClaimNumber & "' "
    Forms!frmClaimsParent.Top = 1440
    Forms!frmClaimsParent.Left = 1440

Question by:ssmith94015
    LVL 75

    Accepted Solution

    This always works for me:

    remember:  1440 twips per inch, so convert to inches


    Author Comment

    MX thanks.  I always forget the twips.


    Author Closing Comment

    Did the job.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
    This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA.…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now