Hi,
I was wondering if any one has used the "Query by Form Using Dynamic Query Def" (MS KBA 210242) to create a search form, which searches the main form and a subform within the main form. Currently it works fine to search the Main form, but if I put any criteria into the sub forms to search by, it doesn't filter out any of the records, it still displays all of the records in the main form, but then the sub forms don't display any data.
Thanks for any help.
I was wondering if any one has used the "Query by Form Using Dynamic Query Def" (MS KBA 210242) to create a search form, which searches the main form and a subform within the main form. Currently it works fine to search the Main form, but if I put any criteria into the sub forms to search by, it doesn't filter out any of the records, it still displays all of the records in the main form, but then the sub forms don't display any data.
Thanks for any help.
