MS Access 2010 accdb - Using TempVars open forms either for New Record or Edit Record.
Two sets of forms - One set works perfect but the other will not accept the criteria for New Record
MsgBox checks confirm the Variables are still valid in the 2nd form Open Event yet the If Then does not work.
Just before the If Then, an invalid use of Null message appears.
Any ideas of what could be an issue and or how to further test for the problem.
:banghead:
I can attach the database, if someone has time to review.
Two sets of forms - One set works perfect but the other will not accept the criteria for New Record
MsgBox checks confirm the Variables are still valid in the 2nd form Open Event yet the If Then does not work.
Just before the If Then, an invalid use of Null message appears.
Any ideas of what could be an issue and or how to further test for the problem.
:banghead:
I can attach the database, if someone has time to review.