Okay what is this SQL statement trying to do? Is this running from a 'search' form that you have created? Are you trying to let a user type in a value click a button and it return records with that value?
Try this for the date variable - #" & Date & "#, unsure if that is a string. Also try isolating the problem by removing all your criteria in the WHERE clause and then add them back in one by one, at least you can see where the problem occurs.
The problem is probably is with the date: VB will convert the date to a string, but SQL will not convert the string back to a date unless you use the #'s.
As a debugging tip, use a string to hold the SQL statement, that way you can "watch" the string to make sure the statement is actually formatting correctly.
strSQL = "SELECT FOX_SMF.* FROM FOX_SMF WHERE (((FOX_SMF.C_ISS_GRP) = 'FT') And ((FOX_SMF.I_TICKER) Like '" & FindTick & "*') And ((FOX_SMF.D_EXP_DT) > #" & Date & "#)) ORDER BY FOX_SMF.I_ASSET_ID;"
To insulate yourself from varying default date formats from PC to PC, use this in place of Date:
This will allow you to determine if the problem is with getting the correct information into the SQL statement or if the problem is with the execution of the SQL statement.