I totally new to Access.
I created 2 forms with a button on the main form to call up the second, e.g.
mileage exp.
I have an expression on the second form to subtract start and finish
mileage, I want the result to display on the main form.
My difficulty is, the result from the second form will appear in the correct
field but in all the records on my main form. I have set up relationships
from the result field on the second form to the field on my main form. I
also used the OnCurrent expression.
I would like to link the correct fields to the correct records and I don't
really want to create a sub-form because it shows on the main form and gives
a cluttered look.
If possible I would like to have a save button that would close the second
form so I can continue entering data before moving onto the next record,
with the mileage exp field empty.
I trawled through the help, maybe I don't know how to phrase the correct
question.
Many Thanks in advance
Tom Brett