B
BruceM
I am using Allen Browne's ConcatRelated function in a form's Current event
to concatenate child records into an unbound text box. I am also using
Stephen Lebans's command buttons subform so that I can have autorepeat for
command buttons, enabling me to scroll through records by pressing and
holding the Next or Previous button, the same as if I was using the built-in
buttons.
Everything works fine, but the ConcatRelated function (executed in the
Current event, not the record source query) takes a little while to execute,
so scrolling using the subform command buttons (or the scroll wheel or the
built-in buttons, for that matter) is rather slow. When I disable the
ConcatRelated code the scrolling happens much more quickly. I wonder if
there is a way to tell Access not to run the Current event until the user
has been at the record for a half second or something. I don't necessarily
need to do it as I have described, but that is the effect I am seeking.
I have looked at a Sleep function, but that just adds more time to the
Current event, which has to process no matter what.
If the use of the Timer event could come into play, I should note that I am
already using it for Roger Carlson's automatic logoff technique.
As an aside, I marvel anew at the amount of code and other assistance that
very talented people make available for general use.
to concatenate child records into an unbound text box. I am also using
Stephen Lebans's command buttons subform so that I can have autorepeat for
command buttons, enabling me to scroll through records by pressing and
holding the Next or Previous button, the same as if I was using the built-in
buttons.
Everything works fine, but the ConcatRelated function (executed in the
Current event, not the record source query) takes a little while to execute,
so scrolling using the subform command buttons (or the scroll wheel or the
built-in buttons, for that matter) is rather slow. When I disable the
ConcatRelated code the scrolling happens much more quickly. I wonder if
there is a way to tell Access not to run the Current event until the user
has been at the record for a half second or something. I don't necessarily
need to do it as I have described, but that is the effect I am seeking.
I have looked at a Sleep function, but that just adds more time to the
Current event, which has to process no matter what.
If the use of the Timer event could come into play, I should note that I am
already using it for Roger Carlson's automatic logoff technique.
As an aside, I marvel anew at the amount of code and other assistance that
very talented people make available for general use.