mouse move

[JohnE]

I am attempting to do a mouse move to show another form with a definition in
it. When I use the following the form opens and so on but it begins to
flicker badly as if it was caught in a loop. When I go off the label, the
form goes away as expected. What is wrong (and I sense there is) with the
following:
Me.lblProvision1.Caption = "Provision 1"
DoCmd.OpenForm "frmProvisionDefinition"
Forms!frmProvisionDefinition!lblProvisionDefinition.Caption =
"Provision 1"
Forms!frmProvisionDefinition!txtProvisionDefinition.SetFocus
Forms!frmProvisionDefinition!txtProvisionDefinition.Text = "Vouchers
will be input within " & _

If anyone can assist, thanks in advance. I did not put all the text in as
it is rather long.
*** John

 

[Graham R Seach]

John,

It seems to keep setting the label caption and opening the form. That'd be
where the flicker comes from. I think what you need to do is test if the
form is already open, and if so, don't try to open it again. The same with
the label caption.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html