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.