VB code for param with NULL value ???

[suel]

I have a SQL Sp that has a variable no. of params (uses = NULL in the declaration). This works fine if I use this SP in a CReport, within the s/w, but I somehow need to code in VB this NULL values bit ... Can anyone help ????

This is the code presently :

Call De1.slFind_Errors_Rpt(hcode, survYear, speriod)

Set params = rep.ParameterFields

For i = 1 To rep.Database.Tables.Count
    rep.Database.Tables(i).SetLogOnInfo MYSERVER, MYDB, tuid, tpid
Next

For Each param In params
         ' NB .. Params are case sensitive
            Select Case param.ParameterFieldName
            Case "@hcode"
                    param.ClearCurrentValueAndRange
                    param.AddCurrentValue hcode
            Case "@survyear"
                    param.ClearCurrentValueAndRange
                    param.AddCurrentValue survYear
            Case "@speriod"
                    param.ClearCurrentValueAndRange
                    param.AddCurrentValue speriod
            End Select
            
        Next

many thanks
Suel