For 1) I think I'd open a recordset, applying the criteria as "...WHERE Field1 Is Null OR Field2 Is Null OR..." . If the rs count is zero, don't bother opening second form for adding values. If > 0 you can open the second form and base its record source on the same sql statement or pass the rs to the second form (don't think I have ever done that). If passing the rs is doable then you already have a rs that you can edit with the form controls. Or you could create the rs in a standard module and that way, either form should be able to work with the rs.
How do you identify 'incorrect' values? The 2nd approach might just be the same as the 1st.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.