Filter gone when form becomes subform. (A2K)

Topic

New Reply

I build a dynamic filter from criteria entered to a search form.
I open Form (A) and apply the filter with “DoCmd.OpenForm stDocName, , , stCriteria”.
A button on form (A) opens form ( which includes form (A) as a subform.
The filter is gone from the SubForm (A), and it shows all records – although form (A) is still open and filtered.

Does anyone know what is wrong? Thanks!

Randy

Reply | Quote

Replies

Open Form A as a subform to Form B has nothing to do with it being opened by itself. You could open FormA as a subform on any number of other forms. A subform is not considered an open form, in that it is not in the Forms collection.

Reply | Quote