I've defined a simple select query in Access that retrieves data for a particular date. I execute the query from VBA.Is it possible to pass a parameter into the query from the VBA when I execute ...

Ok I want to run a SQL query while using the event procedure VB in MS Access.What I'm doing is trying to select a room of a building.So the form goes : Building (and they pick say Smith Hall) then ...