refresh method

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I'm using (or trying to) images as buttons in my form.
I'm saying I'm not using any command button but just images.
This form is unbound so I have procedures which will add or update the
right table by looking to values on form's controls.
But... by clicking on an image doesn't move the focus away from the last
control, so I will never catch the value of this control.
Thus I added this line as the first line of my procedure:
Forms(myform.name).refresh

and now it seems working.
I would like to know if this workaround is fine or if there will be other
better solutions.

Thanks
 
I don't see any particular problem with using Refresh in this context, but
an alternative would be to place transparent command buttons over the
images. You'll get all the functionality of the command button, while the
form will look just the same to the users.
 
Oh well..this sounds surely better. Althought someone said That overlapping
controls should never be used (memory craving?).
But I will give it a try.

Thanks
 
The performance section of the Access Developer's Handbook does suggest
avoiding overlapping controls, but it is just mentioned in passing, without
further explanation. I expect any performance hit is probably a minor one. I
have never found it to be significant myself, and I'm sure the authors of
the ADH would have gone into more detail if they considered it a major
issue. And of course, calling the Refresh method has performance
implications too.

My suggestion would be to keep a copy of your form as it is now, add the
transparent command buttons to another copy of the same form, and compare
the two copies to see whether there is any significant difference.
 
Back
Top