requery subform after "on load" event?

[gangel]

Hey ppls,

Probably an easy question but ive tried afew things and no luck!

When my db opens, i run a module which checks if certain criteria are being met by my data.
In this case, have certain settlements occured today that arent marked as "settled"

Anyway, the code works fine, and i have it "on load' instead of Current as i only want it to fire once each time the program is opened.

the issue is that the main page subform runs off data and looks at UNSETTLED data...

I run the code onload, it registers dates and makes the correct data settled now, but the subform is still looking at the data bfore the changes occured. If i go away from the page and come back it is correct!

So i tried doing me.navigationsubform.requery and it doesnt work.

What am i doing wrong and can i get any opinions/ideas please

Thanks in advance!
Gangel

[davegri]

If the startup code doesn't require any data fields from the form to work properly, check out the autoexec macro. It will run code at startup. Have that code do its thing and then have it load the form. If you do it this way, remove the form name from the Access Options 'Display Form:'.

[Missinglinq]

When a Form has a Subform, the order of events, on opening, is
Open Subform
Load Subform
Current Subform
Open Main Form
Load Main Form
Current Main Form

I'm not sure I understand your scenario, and it may be that davegri's suggestion will work, but it sounds as if you need the OnLoad event of the Subform to run again after the Main Form has loaded, rather than Requerying the Subform. If so, I'd Call the OnLoad event of the Subform as the last line of the OnLoad event of the Main Form.

Linq ;0)>

[Micron]

Records are being changed...

I run the code onload, it registers dates and makes the correct data settled now, but the subform is still looking at the data bfore the changes occured

This is not how you requery a subform: me.navigationsubform.requery
I believe the syntax is something like

Forms("MainFormName").Controls("subformControlName").Form.Requery

NOTE: subformControlName is not the name of your sub form, but the control that contains it
The reason it works when you close and reopen is that the forms naturally become in sync again.
EDIT: I would requery the subform, not reload it. No telling what can happen to the form data by doing that since no code was provided.