Getting Error Message

[Brogrim]

I have a text field that I am trying to include in a query, when I try and run the query I get the following message

Invalid Arguement

It was running fine and now I am getting this message

 

[PHV]

Can you please post the SQL code of your query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Brogrim]

Hope this helps

SELECT tblMembership.MembershipID, tblMembership.FirstName, tblMembership.SecondName, tblCounty.CountyID, [HouseNo] & " " & [HouseLetter] & " " & [Address1] & " " & [Address2] & " " & [Address3] & " " & [County] & " " & [PostCode] AS Address, tblMembership.DOB, tblMembership.PrimaryDisabilityID, tblMembership.GenderID, tblMembership.TitleID
FROM (tblCounty INNER JOIN tblMembership ON tblCounty.CountyID = tblMembership.CountyID) INNER JOIN tblBadge ON tblMembership.MembershipID = tblBadge.MembershipID
WHERE (((tblMembership.FirstName) Like "*" & [Forms]![frmSwitchboard]![txtFirstName] & "*")) OR (((tblMembership.SecondName) Like "*" & [Forms]![frmSwitchboard]![txtSecondName] & "*")) OR (((tblCounty.CountyID) Like "*" & [Forms]![frmSwitchboard]![cboCounty] & "*"))
ORDER BY tblMembership.FirstName, tblMembership.SecondName;

 

[Brogrim]

I am now getting an error message when trying to open the table in datasheet view, it will allow me to look at the design view but not the datasheet

Starting to Panic

 

[PHV]

When you try to execute this query from the SQL view pane of the Query designer window, where go the cursor after the error ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Brogrim]

A message box just appears