I have a continuous subform (certification) displaying certification data for the selected resident on the form (fResidentMain). My goal is to highlight a field on the subform (effective date field) for the selected resident on the form If the record for that selected resident is newly added to certification table. Any records added to the certification table which the subform is pulling from via query needs to be highlighted as long as those records are newly added after loading database. Data load is achieved through an automated process pulling from an Excel file to populate tables. Attached file displays the snapshot of the form.
How do I highlight the "effective date" field on the subform under Certifications tab to help the user paying immediate attention as the newly added certification info on a selected resident? Also, for the next load highlighted records should be un-highlighted for the new records with the next load.