How to display last record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I'm trying to add a field to a form of Project #s and Project Names which
will display the last Project # which was added to that form. I've had no
luck so far.

thanks,
Roger
 
thank you, that worked!

Allen Browne said:
If the last project number is the highest one, you could just use this in
the Control Source of your text box:
=DMax("[Project #]", "tblProject")

If you need more than that, see the ideas in this article:
http://www.mvps.org/access/queries/qry0020.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

vaportrailsf said:
Hi,
I'm trying to add a field to a form of Project #s and Project Names which
will display the last Project # which was added to that form. I've had no
luck so far.

thanks,
Roger
Click to expand...
Click to expand...
 
Back
Top