Hello everyone! I have two subforms on one main form. The detail form is a continuous form called 'qryMeterReadingsForm.'
I'm trying to create a textbox control on the header form and set it equal to a prevoius record from the query (or table) that matches whatever is selected in the combobox for the TruckNumber. i.e., the bound MeterStart control should always be the previous MeterStart value for each truck. (Typically this is the previous day).
I thought I would place something like the following in the code but not sure I'm even on the right path here.
I'm attaching a copy of the database here for reference.
Thank you in advance for any assistance.
I'm trying to create a textbox control on the header form and set it equal to a prevoius record from the query (or table) that matches whatever is selected in the combobox for the TruckNumber. i.e., the bound MeterStart control should always be the previous MeterStart value for each truck. (Typically this is the previous day).
I thought I would place something like the following in the code but not sure I'm even on the right path here.
=DMax("[Meter1Start]","tblMeterForm","[TruckNumber]= " & [Forms]![frmMeterReadingsHeader]![cboTruckNumber])
I'm attaching a copy of the database here for reference.
Thank you in advance for any assistance.