S
Silvio
I have a form with two subforms in it, Sub1 and Sub2. Sub1 is a child of the
main form. Sub2 is not related to anything. The main form has a List Box to
filter records; Sub1 will display any child record associated to the record
selected in the List Box of the Main Form. However, if Sub1 does not have any
record to show (no Child), then the user will use Sub2 to select one and with
a command button located on the main form, the selected record (from Sub2)
will become a child record (via vba code) to the record selected from the
List Box on the Main Form. The problem I am having is that Sub1 does not show
the newley associated child until I close and re-open the main form. I have
tried .requery .refresh .repaint for both, the main and the subform, but
nothing seems to work. Any suggestion?
Thank you folks!
main form. Sub2 is not related to anything. The main form has a List Box to
filter records; Sub1 will display any child record associated to the record
selected in the List Box of the Main Form. However, if Sub1 does not have any
record to show (no Child), then the user will use Sub2 to select one and with
a command button located on the main form, the selected record (from Sub2)
will become a child record (via vba code) to the record selected from the
List Box on the Main Form. The problem I am having is that Sub1 does not show
the newley associated child until I close and re-open the main form. I have
tried .requery .refresh .repaint for both, the main and the subform, but
nothing seems to work. Any suggestion?
Thank you folks!