Using TempVars for Form Open Criteria (1 Viewer)

PNGBill

Win10 Office Pro 2016
Local time
Today, 22:25
Joined
Jul 15, 2008
Messages
2,271
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.
 

PNGBill

Win10 Office Pro 2016
Local time
Today, 22:25
Joined
Jul 15, 2008
Messages
2,271
Further tests show the issue is the new form not accepting the vba RecordSource in the Open Event.
What could be causing this ?
 

PNGBill

Win10 Office Pro 2016
Local time
Today, 22:25
Joined
Jul 15, 2008
Messages
2,271
:) Resolved !! I just noticed the Transaction Table was not in Relationships. Added it a Wala, the forms work fine.
 

Users who are viewing this thread

Top Bottom