Which runs first recordsource or vba? (1 Viewer)

[Djblois]

I was thinking which runs first the recordsource or vba? Reason I am asking is I have a lot of forms that have the recordsource set to a query that uses a date variable. Then on the OnLoad event I change the variable to default to today. If the query in the recordsource runs first that means the query would run twice, initially and then again when I re-query after I change the variable. Should I start the form with a blank recordsource then add it in the onLoad event?

 

[arnelgp]

the Form's Load event fires first.
No need to requery.

 

[theDBguy]

Hi. Take a look at this link. Hope it helps...