It used to work...

[SF]

Hi,

I had my contact search form which work well before. The rowsource of my
list to display the all records before search is shown below:

SELECT tblContacts.Co_ContactID, [Co_FirstName_e] & " " & [Co_LastName_e] AS
Name, tblFunction.FC_FUNCTION_ENGLISH AS [Position],
tblOrganization.Org_Abbreviation, * FROM tblOrganization INNER JOIN
(tblFunction INNER JOIN tblContacts ON tblFunction.Fc_FunctionID =
tblContacts.Co_PositionID) ON tblOrganization.Org_ID = tblContacts.Co_OrgID
WHERE (((tblContacts.Co_ContactID)=False)) ORDER BY [Co_FirstName_e] & " " &
[Co_LastName_e];

After upsize to SQL Server 2005, I got an error at
"tblContacts.Co_ContactID)=False", why SQL Server did not support the word
"false"?

SF

 

[John Spencer]

Don't know, but try
tblContacts.Co_ContactID=0
and see if that works.

Also, you might check the field type of the SQL table and see if it is
an number type.
'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================