Recent content by amalfi93

I have created a photographic log using access and a series of pictures that I have taken. I have some problems and have searched the forum to no avail. Here is a summary of what I have done so far: 1. created a table with a field that contains the complete path and filename for each photo...

Jon - I think the DMAX function will solve my problem. Thanks again for your help. Cheers

still trying... I used the code from dcx693 and unfortunately it sets the default value of the current record (text box in the data entry form) = to the value of the previous record (same field). In a table, I have two fields (call them Field1 and Field2). I have created a form with text boxes...

more info... Jon- Thanks for the response. I have created a form for entering automobile fuel purchases and recording the odometer reading at the time of fueling. I would like to display the fuel economy (miles per gallon) for each vehicle in order to keep track of vehicle performance. In...

I would like to be able to populate a text box on a form with a value (field = MILES) from the previous record. I would then like to use a calculated control to subtract the previous MILES value from the MILES value of the current record. Any help would be appreciated.