Solved For my benefit only?

[Gasman]

Helping someone on another forum, the query below did not work?

SELECT ItemT.ItemDescription, ItemT.Brand, ItemT.Model, ItemT.SerialNumber, ItemT.Size, ItemT.Color, ItemT.Dealer, ItemT.Category, ItemT.Room, ItemT.Cost, ItemT.Tax, ItemT.ReplValue, ItemT.FacWarrEXP, ItemT.ExtWarrEXP, ItemT.PurchaseDate
FROM ItemT
WHERE (((ItemT.Model) Like "*" & [Forms]![MainMenuF]![SearchBox] & "*"));

I did manage to get it to work using a Tempvar, then discovered that if I used

SELECT ItemT.ItemDescription, ItemT.Brand, ItemT.Model, ItemT.SerialNumber, ItemT.Size, ItemT.Color, ItemT.Dealer, ItemT.Category, ItemT.Room, ItemT.Cost, ItemT.Tax, ItemT.ReplValue, ItemT.FacWarrEXP, ItemT.ExtWarrEXP, ItemT.PurchaseDate
FROM ItemT
WHERE (((ItemT.Model) Like "*" & [Forms]![MainMenuF]![SearchBox].Value & "*"));

the query worked?

I also did have issues when trying to assign the control value to a TempVar, stating they could not contain objects. Used the .Value property on each.
So it appears that the default property was not being used for the control? Specifically using .Value worked?

Edit: Ok, I forgot the Tempvar assignment must have the .Value property of a control, but AFAIK the posters original code should have worked?
I have similar in some code of mine, just that I use a TempVar from an InputBox.

Just tried a new query and that also worked fine?

SELECT tblFoods.*, tblFoods.FoodID
FROM tblFoods
WHERE (((tblFoods.FoodID) Like "*" & [Forms]![frmDailyEntry]![sfcsfrmDaily].[Form]![cboFoodIDFK]& "*"));

Went back to that DB and removed the .Value property and now that works?

Go figure.

 

[Pat Hartman]

Your code is out of context. Are you posting the string in a querydef or are you posting a string you are building in VBA? You can't use .Value in a querydef.

 

[Gasman]

Your code is out of context. Are you posting the string in a querydef or are you posting a string you are building in VBA? You can't use .Value in a querydef.

I would beg to differ?

Querydef

SELECT ItemT.ItemDescription, ItemT.Brand, ItemT.Model, ItemT.SerialNumber, ItemT.Size, ItemT.Color, ItemT.Dealer, ItemT.Category, ItemT.Room, ItemT.Cost, ItemT.Tax, ItemT.ReplValue, ItemT.FacWarrEXP, ItemT.ExtWarrEXP, ItemT.PurchaseDate
FROM ItemT
WHERE (((ItemT.Model) Like "*" & [Forms]![MainMenuF]![SearchBox].value & "*"));

 

[Pat Hartman]

I would beg to differ?

Then enough people have made the error and complained so that MS changed the querydef to recognize the control properties. Good to know. Thanks.

 

[Pat Hartman]

Will a query that references control properties be recognized by Excel?

 

[Gasman]

Will a query that references control properties be recognized by Excel?

No.
However does not recognise the query when the property is removed either?