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