I am trying to build a search form (It is an unbound form)
I have a form with 8 combo boxes total that are similar in design and three text boxes. I wanted the functionality where the user could enter part of a name and still get a result.
For example, each combo box combo box that has 2 columns, one of them shows the policy_ID and the corresponding policy name so it easier for the user to pick a choice. I need to be able to search the entire contents of the combo (or just the first column) containing the Policy_ID to add it to the filter? Is this possible? (In the table/query I am filtering it just stores the ID, but I have the ID and Policy Name in the combo for the user to choose easier)
This is my code so far:
If Me![cboPolicy] <> "" Then
sCriteria = sCriteria & " AND qrySearchCriteriaSub.Policy_ID Like """ & Policy & "*"""
I have a form with 8 combo boxes total that are similar in design. I wanted the functionality where the user could enter part of a name and still get a result. If this is not possible, I still need it to search on the column with the ID and ignore the rest to return query results.
I would also like to know how to hide the subform until the results are given?
I have a form with 8 combo boxes total that are similar in design and three text boxes. I wanted the functionality where the user could enter part of a name and still get a result.
For example, each combo box combo box that has 2 columns, one of them shows the policy_ID and the corresponding policy name so it easier for the user to pick a choice. I need to be able to search the entire contents of the combo (or just the first column) containing the Policy_ID to add it to the filter? Is this possible? (In the table/query I am filtering it just stores the ID, but I have the ID and Policy Name in the combo for the user to choose easier)
This is my code so far:
If Me![cboPolicy] <> "" Then
sCriteria = sCriteria & " AND qrySearchCriteriaSub.Policy_ID Like """ & Policy & "*"""
I have a form with 8 combo boxes total that are similar in design. I wanted the functionality where the user could enter part of a name and still get a result. If this is not possible, I still need it to search on the column with the ID and ignore the rest to return query results.
I would also like to know how to hide the subform until the results are given?