[AccessD] Prompt after Form loads

Francisco,

    As far as practicable, it is considered desirable to avoid activation of form's timer. Following course of action is suggested.

    Use a plain temporary form (it need not have any controls at all) to open the main form (named F_Main). Put the code given below in Open event of this form. 

    Now, whenever you open the the temporary form, the main form will be displayed normally along with the prompt - as desired. (In the meanwhile the temporary form will close by itself - the user will not become aware of it).

Regards,
A.D.Tejpal
--------------
================================
Private Sub Form_Open(Cancel As Integer)
    DoCmd.OpenForm "F_Main"
    MsgBox "Pl Check The Values"
    Cancel = 1
End Sub
================================

  ----- Original Message ----- 
  From: Francisco Tapia 
  To: Access Developers discussion and problem solving 
  Sent: Wednesday, September 01, 2004 21:58
  Subject: Re: [AccessD] Prompt after Form loads


  On Timmer w/ a static variable is what I ended up using (plus after it
  fires I shoot the timer interval to 2hrs (more than enough time)  so
  it hopefully won't fire again until after their session is done.

  On Wed, 1 Sep 2004 08:41:20 -0700, Francisco Tapia <fhtapia at gmail.com> wrote:
  > Just tried it and the OnCurrent event also fires before the form is
  > loaded :(, gonna try the OnTimmer...
  > 
  > 
  > 
  > On Wed, 1 Sep 2004 08:35:54 -0700, Francisco Tapia <fhtapia at gmail.com> wrote:
  > > I will try this option Gustav, thanks :D.
  > >
  > > btw, Rocky... What I meant by autoload was that in the Form_Load event
  > > I have code that loads data to the form. because it was in the
  > > form_load event, the prompt was occuring before the user had a chance
  > > to see the form.
  > >
  > > On Wed, 1 Sep 2004 12:34:56 +0200, Gustav Brock <gustav at cactus.dk> wrote:
  > > > Hi Andy and Francisco
  > > >
  > > > I would suggest OnCurrent.
  > > > To prevent multiple prompts, set a static flag:
  > > >
  > > >   Static booIsPrompted As Boolean
  > > >
  > > >   If booIsPrompted = False Then
  > > >     ' Ask if you user wish to load data.
  > > >     <code>
  > > >     booIsPrompted = True
  > > >   End If
  > >
  > > --
  > > -Francisco
  > >
  > 
  > 
  > --
  > -Francisco
  > 


  -- 
  -Francisco