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...
 
You must log in or register to reply here.

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

Similar Threads

filtering a form based on the values of a subform 0
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
How do I invoice a cost to a custom built MS Access Accounting Database? 0
Multiple Items Form Issues 2
No idea how to do this.. 0
Update table from unbound field in form 1
Custom numbering records in a subform 1
Drop down field on form 5

Back
Top