Combo box value to return all values

[GoatieEddie]

I have a combox box with managers names in it.
I then have a subform with various totals on it that works properly for each any every manager by using master/child fields.

I thought that if I added "*" to the combo list values, I could select this and have a total for all managers. This doesn't work. Can someone tell me what value I need to put in the combo if I want the subform to total everybody.

Many thanks,
GE

 

[AlexMidd]

'*' only works with the 'like' operator. Using child/master fields is looking for an exact match. You could try using a query instead with the 'like' operator and using this instead but you would have to "unlink" the subform from the main one and update it with code, and this can be finicky.

Have fun! )

Alex Middleton