John Bartow
john at winhaven.net
Wed Sep 27 17:58:23 CDT 2006
Thanks Gustav
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Then you can reduce to:
= "'" & DMax("[ItemNumber]", "tblJobDetail", "[JobNumber] = '" &
[Forms]![frmProject]![txtJobNumber] & "'") + 1 & "'"