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.
>
>
>Explain for me what you mean by %. Is it a literal or are you referring
>to a wildcard operator? (My keys are integer)
>

Sorry, some of my old SQL slipped in there. Here is the snippet:
Actually % isn't used, but "" as shown below. The view in this sample would have a filter:
color_field LIKE ?lcColor

#DEFINE ALL_LOC "(All)"

lcColor = IIF(THISFORM.cboColors.VALUE = ALL_LOC, "", ALLTRIM(THISFORM.cboColors.VALUE))

REQUERY("your_view")