By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,356 Members | 2,752 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,356 IT Pros & Developers. It's quick & easy.

Last Record in a Table

P: n/a
I have a Switchboard I created that has the program version at the
bottom. I have a table with version history in it that I maintain
everytime I make changes and release it to the users. Currently I
have to update the switchboard field manually as it is an unbound text
box. Is there a way that I can have the Field look for the last
record in my version table and grab the version field?

Thank you,
Chris

Feb 13 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"chris" <ch**********@yahoo.comwrote in message
news:11*********************@k78g2000cwa.googlegro ups.com...
>I have a Switchboard I created that has the program version at the
bottom. I have a table with version history in it that I maintain
everytime I make changes and release it to the users. Currently I
have to update the switchboard field manually as it is an unbound text
box. Is there a way that I can have the Field look for the last
record in my version table and grab the version field?

Thank you,
Chris
Try using DMax as the data source for the txt box:

=DMax("MyField","tblVersion")

Regards,
Keith.
www.keithwilby.com
Feb 13 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.