If you put the code to modify the form's recordsource in the form's open event, that would guarantee the form was open when the assignment was made.
Excess Access
Windows 11 
Access 2019
If you put the code to modify the form's recordsource in the form's open event, that would guarantee the form was open when the assignment was made.
VIP
Windows 10 Access 2010 32bit
If you don't want user to see data until RecordSource is set, open form hidden then after RecordSource is set, unhide. Otherwise, stay with the QueryDefs code.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Security level 2012 cannot find the referenced form "Multiply Dialog"
Can't find referenced field error
Is there a way to code around Error 2450: Access can't find the referenced form?
Posting Permissions
Reply With Quote