[AccessD] Prompt after Form loads

I have tried this as well, and I do get the "Hello" Message box,
however the user would have to click off the form and then back on
before they saw this message.... :|.

remember my production form does this:

Form Open -> set some object classes,
Form Load -> open recordsets load fields
Form Timer -> after 1ms, check if key data fields match defaults.

Access 2000 (ADP)

On Wed, 1 Sep 2004 16:57:50 -0400 , Heenan, Lambert
<lambert.heenan at aig.com> wrote:
> The Activate event should do the trick, you just need to keep tack of how
> many times it fires. I just tried this out with a form/subform setup, and
> the following code seems to work just fine
> 
> Private Sub Form_Activate()
>  Static lngLoaded As Long
>     lngLoaded = lngLoaded + 1
>     DoEvents
>     If lngLoaded > 1 Then MsgBox "Hello "
> End Sub
> 
> The DoEvents does not seem to be necessary, but I thought I'd put it in
> anyway.
> 
> What I found was that the entire form and subform was displayed with the
> exception of some controls on the form which have statements like this...
> 
> =Count([cFaceAmount])
> 
> ... in their control source property.
> 


-- 
-Francisco