Display a variable value on a switchboard

Posted on 2007-10-11
Last Modified: 2013-11-28
I have made a switch for an update process.
I'd like to show the current maximum date of the records in the main table as a reference.
I've made a query and a one-record table to create the value and tried to put it in a textbox on the form.
That's not gettin' it.
Can I even do what I'm trying?

Question by:tmccar10
    LVL 9

    Expert Comment

    Try this:

    Create a separate form that includes only the single textbox you'd mentioned above, using the query as the recordsource for that form.

    Then, on the switchboard form, insert the form you just made above as a subform.

    The value should display properly if you use a subform in this manner.
    LVL 38

    Accepted Solution

    Using your textbox approach, place the following as the control source:

    = DMax("[YourDateField]", "YourMainTable")

    Author Comment

    Thanks puppydogbuddy-
    Precisely what I was after!  
    Apparently the quotes and brackets are important...guess I never managed to get to that paricular combination!

    Thanks. It's one of those times when the other solution exactly matches the need. Thanks for the very useful  information
    LVL 38

    Expert Comment

    You are welcome.  Glad I could help you resolve your problem.
    LVL 9

    Expert Comment

    Just glad to hear you got it working!!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Suggested Solutions

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    737 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

    18 Experts available now in Live!

    Get 1:1 Help Now