I am using a command object for my data report and it has a parameter represents the first two characters of the last four digits zipcode(given by a user). I need to pull all records that contain those two digits. I know I will need the wildcard LIKE "XX%", however it didn't work when I pass the parameter to my command object in my DataReport_Initialize event. How do I go about it? I am using Access 2000 and VB6sp4.

Here is my code in the DataReport_Initialize event....

'frmMatchList.txtZipCode2.text contains 'XX%'

'*******
DeTMS.cmdTMPmatchlistZC_Grouping frmMatchList.txtZipCode2
'*******

Thanks!!