Where condition

[DavidTCH]

I am using Access 2010 to Search for a Record. What is wrong with this "Where condition" : ="[StockName]=" & "'[TempVars]![VarStockName]'". The field in the table call tblStock is "StockName" and its a text field. The Variable: VarStockName is also a text. Why can't it work? Please Help to correct. Tq

[Bob Fitz]

Perhaps it should be:"[StockName]='" & [TempVars]![VarStockName] & "'"

[John_G]

You have the quotes in the wrong place. Try this:

="[StockName]= '" & [TempVars]![VarStockName] & "'"

Notice that the reference [TempVars]![VarStockName] is outside all quotes.

It helps if when something "doesn't work" you say why it doesn't, and state what the error message is (if there is one).

[DavidTCH]

Understood. Thank you very much. Problem solved

You have the quotes in the wrong place. Try this:

="[StockName]= '" & [TempVars]![VarStockName] & "'"

Notice that the reference [TempVars]![VarStockName] is outside all quotes.

It helps if when something "doesn't work" you say why it doesn't, and state what the error message is (if there is one).