subform to show latest information

[scopes456]

I created a vehicle database that includes a sevice subform to track service history. The main form is bound to the vehicle table that tracks the vehicles we have. (Vehicle_ID). The service history has its own table that stores its history and is link to the vehicles table. I created a report that shows my vehicle and its last history item. When i click on it, it will bring up the vehicle form where you can add information. Is there a way to create the form, so when i enter the latest information and i click on it, it will bring up my main form, and in my subform svc history, display the lastest information.
Thanks in advance

 

[GinaWhipp]

If all you want to see is the latest information first then use a query for the Record Source of the Form and sort it accordingly. If that is not what you want then please elaborate.