Search results

If I define a variable 'DebitTot' in Sub SaveClick and use DMax to assign a value to it, can I then refer to that variable and value in a Sub AddNewClick? Private Sub SaveClick Dim DebitTot As String DebitTot = DMax(Blah Blah Blah) End Sub Private Sub AddNewClick PastDue = DebitTot End Sub...

Can anyone give me the proper syntax to due this? DMax("[CurrReadDate]", "ReadingTbl", "[AccountNo] =" & Me.AccountNo) - 1 It's not working the way it is above, and I actually need the record right before the one with the most recent date in order to do what it is that I am trying to do...