So..... I know this has been "dead" for awhile, but I've just come across it. I would love to have a search function kind of like this for my database. However, I'm having a few problems. I tried to emulate Query1 using my own tables and stuff, but I get an error, and I'm not sure why (I'm also not sure if I'm remotely doing the SQL thing right either....)
My "code":
SELECT [CustomerOrderDetails].CustomerOrderID, [CustomerOrderDetails].CompanyName, [CustomerOrderDetails].DateShipped, [CustomerOrderDetails].PartID, [CustomerOrderDetails].SerialNumber, [PurchaseDetails].PurchaseID, [PurchaseDetails].VendorID, [PurchaseDetails].DateReceived, [PurchaseDetails].PartID, [PurchaseDetails].SerialNumber, *
FROM [CustomerOrderDetails], [PurchaseDetails]
WHERE ((([CustomerOrderDetails].CustomerOrderID) Like "*" & [Forms]![Search]![Search2] & "*")) OR ((([CustomerOrderDetails].CompanyName) Like "*" & [Forms]![Search]![Search2] & "*")) OR ((([CustomerOrderDetails].PartID) Like "*" & [Forms]![Search]![Search2] & "*")) OR ((([CustomerOrderDetails].SerialNumber) Like "*" & [Forms]![Search]![Search2] & "*")) OR ((([PurchaseDetails].PurchaseID) Like "*" & [Forms]![Search]![Search2] & "*")) OR ((([PurchaseDetails].VendorID) Like "*" & [Forms]![Search]![Search2] & "*")) OR ((([CustomerOrderDetails].DateShipped) Like "*" & [Forms]!{Search]![Search2] & "*")) OR ((([PurchaseDetails].DateReceived) Like "*" & [Forms]![Search]![Search2] & "*")) OR ((([PurchaseDetails].PartID) Like "*" & [Forms]![Search]![Search2] & "*")) OR ((([PurchaseDetails].SerialNumber) Like "*" & [Forms]![Search]![Search2] & "*"))
ORDER BY [CustomerOrderDetails].CustomerOrderID, [PurchaseDetails].PurchaseID;
Is this even remotely close to what I need? I will attached a blank copy of my database, and I'm hoping someone can point me in the right direction....