I have a subset of data from a table and within that subset i want to find the highest value in a field... Then i need to add 1 to the highest number... As you can tell i have never used the Dmax function here is part of my code so far...
'Gather Current Followups on that Policy
strSql = "SELECT * FROM [dbo_ct1035Followup] WHERE [Policykey] = '" & Pst!policykey & "';"
Set Fst = db.OpenRecordset(strSql, dbOpenDynaset, dbSeeChanges)
' **** Code to figure out the last followup id number
tmpFolID = DMax(Fst!FollowupId) + 1