[AccessD] DMax issue

Darren,
Thanks - that did the trick! I think I must have tried every set of quotes
around the criteria but  this! Just what I needed.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren DICK

When dealing with numbers the syntax you provided is correct - however
JobNumber is actually text so in the Domain Lookup syntax (DMAX) it should
be treated as text

EG - try

=(DMax("[ItemNumber]","tblJobDetail","[JobNumber] =
[Forms]![frmProject]![txtJobNumber]"))+1 

IE = [Forms]![frmProject]![txtJobNumber] now sits INSIDE the double quotes
rather than outside as in your posted syntax