I have posted this previousely to no avail, Can anybody help?
Based upon the selection on a form frmMainMenu another form frmMainForm is displayed with some fields on no-show based upon the selection that was made from frmMainMenu. This is filtered by TblPartID
I would like however to have an autofill on the field "Basecoat Batch Number" however this would not be an autofill from the previous record but the previous record of the corresponding PartID, Is this possible?
The database attached has the AutofillModule, with the On Current property set
Thanks Jeff
Based upon the selection on a form frmMainMenu another form frmMainForm is displayed with some fields on no-show based upon the selection that was made from frmMainMenu. This is filtered by TblPartID
I would like however to have an autofill on the field "Basecoat Batch Number" however this would not be an autofill from the previous record but the previous record of the corresponding PartID, Is this possible?
The database attached has the AutofillModule, with the On Current property set
Thanks Jeff