Retrieving value in last record

J

Joan

How does one retrieve the value of a particular field of the last record in
a table in VBA? Any help with this will be appreciated.

Joan
 
P

PC Datasheet

If your form is based on a table or a query that includes the table ----

Create an unbound textbox on your form and put the following expression in its
Control Source property:

=Max([NameOfTheField])


--
PC Datasheet
A Resource for Access, Excel and Word Applications
(e-mail address removed)
www.pcdatasheet.com

· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top