Hello.
After too many attempts, I have to throw in the towel
Setup:
I have a form with two subforms (1 & 2), one of which has its own subform (2.1)
Procedure:
- An event on subform 1 calls a function on the parent form with a parameter.
- This function calls another function on subform 2 and forwards the parameter.
- The parameter is used as a filter for subform 2.
- The RecordSource for sub-subform 2.1 is updated by the filter for subform 2.
Problem:
- When the query returns more than 13 records, a scrollbar appears - so far so good
- When a query returns >13 records and then a new query returns 2-13 records, the scrollbar disappears - great
- When a query returns >13 records and then a new query returns one record or less, the scrollbar disappears but leaves a grey field which persists until a query which returns 2 or more records is made - what?
Additionally: If a query returns more than 13 records, then 2-13, then 0-1, the form works as intended. The problem only arise when going directly from more than 13 records to 0 or 1.
Please see attached pictures.
My spidey-sense tells me that the problem arise from the fact that I use a continuous form for the sub-subform because I was not able to achieve the intended effect by other means. Thank you in advance for an insight into possible causes of the problem and potential solutions.
Best regards,
hargro