Where clause in a list box issue

[JimO]

Using the code,

ANListBox.RowSource = "SELECT AMID, Game, Year, Location, City, State, Result, GmScore FROM SportsArmyNavyQry ORDER BY Year;"

my button works as planned. If I add a where clause the data fails to show.

ANListBox.RowSource = "SELECT AMID, Game, Year, Location, City, State, Result, GmScore FROM SportsArmyNavyQry WHERE Game = "Army" ORDER BY Year;"

I am at a loss to track down the issue, why the first works and the second does not. If I just use the second "select statement as the source code it works fine.

Jim O

[RuralGuy]

Try changing the internal quotes to single quotes.
ANListBox.RowSource = "SELECT AMID, Game, Year, Location, City, State, Result, GmScore FROM SportsArmyNavyQry WHERE Game = 'Army' ORDER BY Year;"

[JimO]

Thank you so much. That does it job.

Thanks,
Jim O

[RuralGuy]

You're very welcome. Glad we could help.