Combobox or Report

[anaylor01]

Problem #1. In Reports if you add a parameter and select multi-value when I run the report and Select All from the drop down list or if I select more than one value I get "incorrect syntax near ','. I haven't been able to find anything on this error. I am running Sql Server 2005 SP2.

 

Problem #2. In Microsoft Access I can add a Combobox that will return a list of values from a table and will let me assign a sort order.

When the form is loaded there is no value for combobox. The user can leave this value blank. What I like to do is write code that says if the combobox is null then select all.

 

When I try to do this in VB.net the form loads the combobox with values already in the combobox.

 

How can I either fix problem #1 or #2 or both? Thanks for your help.

 

Happy holidays.

[Machaira]

For #1 - can you post the code? What do you mean by "Reports"?

 

For #2 - set the SelectedIndex property of the combo to -1