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
tmccar10Asked:
Who is Participating?
 
puppydogbuddyCommented:
Using your textbox approach, place the following as the control source:

= DMax("[YourDateField]", "YourMainTable")
0
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.