Subform go to new record

[Hazel]

I have one form and one subform

form has customer details

subform has customer service records

i would like to know if when the main form is opened at a certain customer
that the subform could display the last service record and a new record
subform is in datasheet view.

also i have a field in the customer details (form) that needs to have the last service date from the subform filled in

can this be done

 

[ansentry]

Is this what you want to do?

see attached:

 

[Hazel]

Subform go to a new record

Thanks John for this.

Only problem is that i only want the last service date for the customer that is one screen not all of the other customers do you know if i can do this.

 

[ansentry]

New sample attached.