Francisco Tapia
fhtapia at gmail.com
Wed Sep 1 10:41:20 CDT 2004
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