i ve connected the data environment to sql database.
everything works fine.
i ve enabled a search method to search for a particular record in the db, whose function is to search the db and retrieve the record and display through a report.
during the display an error is generated ----- incorrect syntax '"'
and the search method is this.........


CustId = Me.Text1.Text
DataEnvironment1.rscmdcust.Filter = "customerID = '" & CustId & "'"
custdet.Show

custdet is the report to be generated.

PLEASE HELP ME FIX THIS ERROR!!!!!!