I've found Access on startup runs my subform Current Event before anything else.
Can I force it to run the main form Current event first ?
Competent Performer
Windows 10 
Access 2019
I've found Access on startup runs my subform Current Event before anything else.
Can I force it to run the main form Current event first ?
VIP
Windows 10 Access 2010 32bit
Subforms and subreports load before main form.
Could have the subform container control SourceObject property empty in design then set it after main form opens.
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.
Competent Performer
Windows 10 Access 2019
Thank you @June that was a brilliant idea. It's working just fine. Put the source object into Form Open event.
Virtually Inert Person
Windows 10 Access 2016
IIRC, subforms load first, subreports do not. I think you would find it isSubforms and subreports load before main form.
- main report opens
- sub opens
- main loads
- sub load event doesn't fire.
At least that has been my experience with report print preview or report view.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
VIP
Windows 10 Access 2010 32bit
Okay, scratch that about reports. I should have explored first instead of generalizing based on form behavior.
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.
Posting Permissions
Reply With Quote