Simply put, I am trying to pull the data from the previous record / row only in a continuous form for a dive log to keep tabs on total bottom times. All I am doing is pulling the "new total bottom time" from the previous record in to the "old total bottom time" of the current record in order to add the "old total bottom time" to the "bottom time this dive" for the current record to have a number to calculate the "new total bottom time."
This is what I put in the control source;
=DLookUp([NEW TOTAL BOTTOM TIME],[divelog],[ID]=[Forms]![DIVE LOG]![ID]-1)
This is what is shown on the form; #name
What do you see here that I am doing wrong?
This is what I put in the control source;
=DLookUp([NEW TOTAL BOTTOM TIME],[divelog],[ID]=[Forms]![DIVE LOG]![ID]-1)
This is what is shown on the form; #name
What do you see here that I am doing wrong?