John Bartow
john at winhaven.net
Wed Sep 27 12:37:39 CDT 2006
Rocky, The worst thing about using the Domain functions - they are hard to debug (IMO). I'd done the MsgBox thing as you recommended - after putting a watch on the variables, etc. No luck as everything comes through OK except the result! -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Beach Access Software I'd put a statement right before the DMax: MsgBox "*" & [Forms]![frmProject]![txtJobNumber])) & "*" just to see what that snip is evaluating to.