Hello,
I'm trying to use a subform to display a query. The user can enter any two search criterial and I want the subform to bring up all the records that match it. However the problem is when i do the requery for the subform it brings up every record and they have to scroll though each of them.
The criteria is [forms]![PTquery].[Searcha] or [forms]![PTquery][Searchb]. Searh a and searchb are textboxes the user can input.
Thanks
I'm trying to use a subform to display a query. The user can enter any two search criterial and I want the subform to bring up all the records that match it. However the problem is when i do the requery for the subform it brings up every record and they have to scroll though each of them.
The criteria is [forms]![PTquery].[Searcha] or [forms]![PTquery][Searchb]. Searh a and searchb are textboxes the user can input.
Thanks