Access 2000 Overlay control on top of subform

Posted on 2005-05-04
Last Modified: 2008-02-01
I guess we're all pretty familiar with stacking controls on forms to acheive certain effects by hiding certain controls etc.

My boss wants me to overlay a textbox or lable over a (continuous forms) subform so that under certain conditions the control overlays the subform indicating that the form is locked. (although I want to keep the subform visible so the data can still be seen)

Imagine my surprise when after placing a text box 'over' a subform, it stubbornly refuses to 'bring to front' and the subform won't go to back either

I guess subforms are a special case, but i would be interested if anyone has got any ideas or workarounds ...

I can implement an alternative solution, but it would be neat if something approaching the ideal could be done

Question by:Natchiket
    LVL 46

    Assisted Solution

    You can't move a subform to the back.
    Why not just change the background color/picture of the subform?

    Good Luck!

    LVL 39

    Accepted Solution

    Expanding on Gary's suggestion:

    Create an image file that says LOCKED!"   (example: locked.bmp)
    If locked Then
          Me.Picture = "C:\My Folder\locked.bmp)
          Me.Picture = ""
    End If

    You can make the background of all the control transparent to better read the "LOCKED!"
    LVL 17

    Author Comment

    Thanks guys, in the end I just decided to have some text in a box above the subform, I'll condsider an image file solution if my boss still has issues.

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    745 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

    14 Experts available now in Live!

    Get 1:1 Help Now