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...

I downloaded it, and I used the example to figure out the syntax for the DMax() function, but I don't understand how to use the DMax() to get the DateRead and MeterReading from the record just before the last record. In this case that is what I need to do. Because by the time I am entering the...

Okay, But how do I get to what I'm looking for? Any Help would be appreciated. Thanks, Mac

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...

using the Dmax() I could certainly use some samples of your Dmax, and Dlookup functions, if you could. I have a similar assignment, and I am having heck getting the thing to work. However, I have the previousReading, and the CurrentReading as two separate fields, and want to move the...