|
I have a form based on 4 tables. The driving table
simply returns a looked-up name with the other 3 tables each returning a
scrolling region based on the preceding table.
I have been attempting to dynamically size the scrolling
regions to return the number of rows found for each table.
I have the maths working fine and each one works
individually but I have two things which I haven't found a solution for
yet:
Firstly, I seem to have to click into each region to get
it to adjust its size; and
secondly: there is a lot of flashing of the screen as
each one is changed.
I've tried every combination of Set_Focus and Skip To
and table properties for First, Refresh, Recalc, etc that I can think of but not
found the missing ingredient.
One other thing that is related to scrolling regions but
not particularly to this form - as far as I know - is that I am getting some
"Invalid Text Value" error messages - apparently - whenever the linking
(text) columns contain a single quote (as an apostrophe). Is this something that
needs to be reported as a bug (upgrade #80/RC2)?
Thanks & regards,
Alastair. ----------------------------------
A D B Burr, St. Albans, UK. ---------------------------------- [EMAIL PROTECTED] ---------------------------------- |
