Hello,
I have a continuous form which has a textbox whose control source is set to a function which returns a number (more specifically, a string: varNum + "."
This is so each form appears to have a numeric label. This is working... the labels are correct and it looks nice. EXCEPT! For when I scroll it, (it is in a subform) and some of the forms disappear, when they come back after scrolling the other way, SOME, NOT ALL, of the values have changed, as if refreshed! (ex. I have 7 continuous forms, labelled successfully #1 - #7. After scrolling and returning tho, #2 is now #8, #3 is now #9, the rest are as they should be!! etc.)
(The new values are the last count + 1, indicating the function that provides the number was called again).
The SUPER screwy thing is that it's not all the forms, just some of them!!!
This is not a matter of adjusting the function... I have simplified the example to explain more easily what is happening... the issue is to how to stop that danged refresh.
Does anyone know some of the nuances of continuous forms that may present this behavior?
Thank you, very much,
B.
I have a continuous form which has a textbox whose control source is set to a function which returns a number (more specifically, a string: varNum + "."
This is so each form appears to have a numeric label. This is working... the labels are correct and it looks nice. EXCEPT! For when I scroll it, (it is in a subform) and some of the forms disappear, when they come back after scrolling the other way, SOME, NOT ALL, of the values have changed, as if refreshed! (ex. I have 7 continuous forms, labelled successfully #1 - #7. After scrolling and returning tho, #2 is now #8, #3 is now #9, the rest are as they should be!! etc.)
(The new values are the last count + 1, indicating the function that provides the number was called again).
The SUPER screwy thing is that it's not all the forms, just some of them!!!
This is not a matter of adjusting the function... I have simplified the example to explain more easily what is happening... the issue is to how to stop that danged refresh.
Does anyone know some of the nuances of continuous forms that may present this behavior?
Thank you, very much,
B.