Unanswered: Finding differences between data on a form and subform
I have a subform within a form. The form contains data that is linked to a query which is linked to an external table through ODBC. The subform is linked to a table where it contains data that is entered manually.
The subform and form have the same fields, but what I am trying to do is find where the data within the subform and form do not match. Basically, I am thinking of a cell within the subform to be highlighted when it doesn’t match the entry within the query data which is on the form.