• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 134
  • Last Modified:

Display a variable value on a switchboard

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?

Thanks
0
tmccar10
Asked:
tmccar10
  • 2
  • 2
1 Solution
 
sah18Commented:
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.
0
 
puppydogbuddyCommented:
Using your textbox approach, place the following as the control source:

= DMax("[YourDateField]", "YourMainTable")
0
 
tmccar10Author Commented:
Thanks puppydogbuddy-
Precisely what I was after!  
Apparently the quotes and brackets are important...guess I never managed to get to that paricular combination!

sah18-
Thanks. It's one of those times when the other solution exactly matches the need. Thanks for the very useful  information
0
 
puppydogbuddyCommented:
tmccar10,
You are welcome.  Glad I could help you resolve your problem.
PDB
0
 
sah18Commented:
Just glad to hear you got it working!!
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

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