on my app I do have a form/subform set. They are not linked, but the subform is bound to a record set that is constructed on the main form.
on the form, when I press a button, it should list, in the subform, all records in the data set should show. It is a LIST ALL BUTTON.
so my code on the button is:
strFilter = "T03_DocID > 0"
Me.F1401_ListaDocsSelecionados.Form.Filter = strFilter
Me.F1401_ListaDocsSelecionados.Form.FilterOn = True
The record set is ok (contains 5 records and the 5 records' ID [T03_DocID] is greater than 0 for all
however, no record is shown at all! the subform is totally empty
I am attaching screenshots..