Information générale
Catégorie:
Codage, syntaxe et commandes
>I have a form that presents a grid which is based
>on a view. The View has 3 selection criteria, department, location and status which are variables
>macroed in. The form gives users combo boxes to change
>values for each criteria and the grid requeries. It works fine. I Want however to allow the user to select
>ALL for any or all of the criteria but I cant figure
>how to do this since the selection in the query builder
>expects 1 specific value for each.
>
>Any Ideas?
Chris,
I had to do something similar. In the view use LIKE for the comparitor.
then when the user selects ALL pass in % for the value of the parameter.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement