Gustav Brock
gustav at cactus.dk
Wed Sep 1 05:34:56 CDT 2004
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 /gustav > Francisco > I'd go with your OnTimer idea. I think all of the other obvious events will > fire before the form is fully displayed. > -- Andy Lacey > http://www.minstersystems.co.uk >> I have a form which autoloads data to some unbound controls. >> I have a need to prompt the user if he wants to overwrite >> some fields w/ defaults. However since the "IF" is in the >> form_load event it prompts before the form is fully loaded, >> thus the user can't make an informed decision.