Criteria in subQuery problem

[joeKra]

Hi,

i would like to filter my form based on subquery and form textBox
for some reason is it not recognizing the form's text box , i'm using Access '97

Thanks in Advance,

The sql:

SELECT [groupname] & Chr(13) & Chr(10) & [contactperson] & Chr(13) & Chr(10) & Format([phoneday],'(000)000-0000') AS [Contact Person], Contracts.*, Customers.* FROM Contracts INNER JOIN Customers ON Contracts.CustomerId = Customers.CustomerId WHERE (((Contracts.ContractId) In (Select A.ContractID From ContractDetails as A  Where A.TripDate = [Forms]![frmContractsBydate]![txtsearch]  And A.Cancelled = 0)));

 

[joeKra]

NEVER MIND I HAVE MADE A SPELLING MISTAKE !!!