Hello Brains Trust
I have a text field on a form that displays the last date a service was taken for a machine.
This works fine except where a customer has more than one machine. In that case when I use the record navigation buttons to display the next record, the text field shows this date on all records.Code:=DMax("[Service Date]","xServices","MachineNo='" & [MachineNo] & "' AND Catagory='Service'")
Each machine has a unique number, so as I cycle through the machine records, the text box should not display the date because "MachineNo='" & [MachineNo] is not true.
Ultimately what I want to do is to have the last service record display when a button is pressed where another field WorkOutstanding is not blank. The button will only display when the machine currently displayed on the form has WorkOutstanding from the last service.
Obviously I can't proceed until I get the first part working correctly.
Can anyone point out where I am going wrong?
Thank you on advance.