On first reading you could stop at ** and resume at the later ** as I think the problem must be in the part before the first **!

Field X on Form A is the key field for another table T. User enters, eg, "nnnn" in Field X.
If Form A code discovers "nnnn" is not the key to an existing record in table T
Form A opens Form B with acNewRecord and OpenArgs = "nnnn"
When Form...