In my experience, very few of those here that offer advice, use macros. Generally, we prefer to use VBA code, so our experience with macros is limited.
However, I notice that you are using the following expression in your If/Then:
Code:
IsNull([Forms]![frmCount MultLine Import Orders]![InvNoCount])=False
Perhaps that should be:
Code:
Not IsNull([Forms]![frmCount MultLine Import Orders]![InvNoCount])
Later you use:
Code:
IsNull([Forms]![frmCount MultLine Import Orders]![InvNoCount])=True
Perhaps that should be:
Code:
IsNull([Forms]![frmCount MultLine Import Orders]![InvNoCount])