How is the search button working when we have a blank subform in a main form?
I have a main form which has a Subform (blank form) like the following image (Hotels is a multiselect field)
In the report I would like to show the Hotels and Category (from the Subform) so I did the following (using a comma separator):
So my final report is like:
Well my problem is with the search in Remarks..
When I write 'Remarks Contains Promotions' then it returns me only the first record which is correct
When I write 'Remarks Contains Issues' then it returns me only the second record which is correct
When I write 'Remarks Contains Minos' then it returns me nothing.
Why this happens? Is it because the combination of these two fields? The search function only searches in the first field (Category) and not in the whole combination Category+Hotels?
In the report I would like to show the Hotels and Category (from the Subform) so I did the following (using a comma separator):
So my final report is like:
Well my problem is with the search in Remarks..
When I write 'Remarks Contains Promotions' then it returns me only the first record which is correct
When I write 'Remarks Contains Issues' then it returns me only the second record which is correct
When I write 'Remarks Contains Minos' then it returns me nothing.
Why this happens? Is it because the combination of these two fields? The search function only searches in the first field (Category) and not in the whole combination Category+Hotels?