Thank you all for your insights.
As suggested I've created a query that will give me the result I'm after, but I don't know how to get the result in to the text box on the form.
This is the code for the query. (Yes, I'm aware of the spaces in names convention - this is a legacy project)
Code:
SELECT Customers.CustomerID, Customers.CompanyName, [Customer Machine Components].MachineNo, xServices.[Service Date], xServices.[Service Report No], xServices.Odometer, xServices.HourMtr
FROM (Customers INNER JOIN [Customer Machine Components] ON Customers.CustomerID = [Customer Machine Components].CustomerID) INNER JOIN xServices ON Customers.CustomerID = xServices.CustomerID
WHERE (((xServices.Odometer)>0))
ORDER BY xServices.[Service Date] DESC;