Hi All,
I've got a form and subform as below. The main form contains details of a piece of machinery, and the subform has details of each occasion it was serviced. When i'm entering a new record on the subform, is it possible to make the date that particular machine was last serviced appear in a text box on the subform as the default value ? So really, i'd like to see the last value in the ServiceDate field for that machine displayed in the text box
Thanks
tbl_EquipmentList
EquipID PK (Short Text)
EquipmentName (Short Text)
Manufacturer (Short Text)
tbl_ServiceRecords
ServiceID PK (Autonumber)
EquipID FK (Short Text)
ServiceDate (Date)
ServicedBy (Short Text)
PassFail (Yes/No)
I've got a form and subform as below. The main form contains details of a piece of machinery, and the subform has details of each occasion it was serviced. When i'm entering a new record on the subform, is it possible to make the date that particular machine was last serviced appear in a text box on the subform as the default value ? So really, i'd like to see the last value in the ServiceDate field for that machine displayed in the text box
Thanks
tbl_EquipmentList
EquipID PK (Short Text)
EquipmentName (Short Text)
Manufacturer (Short Text)
tbl_ServiceRecords
ServiceID PK (Autonumber)
EquipID FK (Short Text)
ServiceDate (Date)
ServicedBy (Short Text)
PassFail (Yes/No)