I would like to give the user the option of selecting a field in a parameter or printing all of the fields.  In other words, I want the user to be able to select one or multiple vendor names.  I can do that with the parameter.  However, if they left the parameter null or if I set up a selection of All, have the report select all of the vendor names.  Is there a way to do that?

Thanks for your response.  However, the code did not work.  Whenever I run the report and leave the vendor name parameter null, it does not come back with any records.  But, whenever I select two or three vendor names, it brings back the records for those vendors.

Yes, there is a default parameter.  It is a list of about 400 vendor names.  The user wants to be able to pick and choose several vendor names or to be able to have the report run all of them.

Thank you very much DBlank.  That worked for what I was trying to do.

hi DBlank,