[RESOLVED] [2005] Parameter Problem - Need to have sometimes and sometimes not

[jre1229]

Hi,

I have this

Dim FindRecordDA As New OleDbDataAdapter("SELECT * FROM tblSSOPVerificationFormRecords WHERE AutoNumber = ? AND Technician = ? AND Location = ? AND VerificationDate >= ? AND VerificationDate <= ?", cn)
 
        Dim FindRecordDS As New DataSet
 
 
 
        FindRecordDS.Clear()
 
        FindRecordDA.SelectCommand.Parameters.Clear()
 
 
 
        If recordNumberTextBox.Text = "" Then
 
            FindRecordDA.SelectCommand.Parameters.Add("@AutoNumber", OleDbType.VarChar, 80).Value = "*"
 
        Else
 
            FindRecordDA.SelectCommand.Parameters.Add("@AutoNumber", OleDbType.VarChar, 80).Value = recordNumberTextBox.Text
 
        End If
 
 
 
        FindRecordDA.SelectCommand.Parameters.Add("@Technician", OleDbType.VarChar, 80).Value = technicianComboBox.Text
 
        FindRecordDA.SelectCommand.Parameters.Add("@Location", OleDbType.VarChar, 80).Value = locationComboBox.Text
 
        FindRecordDA.SelectCommand.Parameters.Add("@VerificationDate1", OleDbType.Date, 80).Value = SSOPStartDatePicker.Text
 
        FindRecordDA.SelectCommand.Parameters.Add("@VerificationDate2", OleDbType.Date, 80).Value = SSOPEndDatePicker.Text
 
 
 
        FindRecordDA.FillSchema(FindRecordDS, SchemaType.Source, "tblSSOPVerificationFormRecords")
 
        FindRecordDA.Fill(FindRecordDS, "tblSSOPVerificationFormRecords")

I know the "*" isn't correct but how can I make it to where that parameter is nothing and pulls everything?