Hollis,Virginia
HollisVJ at pgdp.usec.com
Sat Mar 20 08:27:19 CST 2004
Me.lblNew.Caption = "You are adding Request Task" &
Nz(DMax((Format("[RequestTask]", """VEN-""0000")), "qry_VenTask")) + 1
When I go to a new record, I want the caption of lblNew to show "You are
adding Request Task VEN-0041", with the RequestTask number formatted with
the 0000s. I am having problems with formatting VEN-0041. Without the
Format('[RequestTask].... I get just the number 0041. I think it is the
placement of my quotes?
Virginia