SubForm EVENT to use after controls are populated

[Peter S.]

I have a subform embedded in a tab control. All my data gets populated into
my textbox controls correctly. The only problem is that I want to check the
textboxes and/or database values to see if they are null to highlight some
text red but can't seem to get the proper EVENT to use because no matter
which event I pick the textbox is always null even though it eventually gets
populated when the form opens. Any ideas on which EVENT to use that occurs
after the UI textboxes and the database is queried.

BTW, I tried this after my requery statement and also after events current,
load etc.
Also as a side question are there any good pointers on the web as to the
sequence of Access form events?

 

[Peter S.]

One other thing is I tried calling a function in my subform from the load
event of my main form and still when I access the textbox the value is null.
I am able to get the name field of the textbox and change colors on my labels
but I can't seem to retrieve the data to determine how I want to affect the
UI.