within the header group, I have called the “Stop Number” from the database (2) and by adding 1, the next header field is produced Each header contains a time.
my details are not visible in order to provide a summary.
when the next header group appears, it has a displays the stop number “2” and as before, a stop 3.
The following is the dlookup I used to look up the time for the 2nd header so I can use a DateDiff to calculate the minutes between each Header time.
dtTime2 = DLookup(“[tTime]”, “PA823-24”, “[PA823-24]![tAMStopNo]=txtStopTwo”). I really don’t expect this formula to work. It is just the 3 or 400th one I’ve tried.

I am able to display current stop number and next stop number, as well as perform simple math calcs such as add etc,etc. but it wont let me use it in a VBA formula. as well as a gzillion different ways, I have tried using .value after the text fields to no avail.

Any ideas?
thanks in advance

Fred

I have tried inserting the formulas in the textboxes themselves and via vba in the code window.
I have tried declaring various number and using it in code