I was trying to write a conditional query in MS Access today, without success. Here's the problem.<BR><BR>I have a field (myField) that is a lookup to a table (myTable) in the query. myField stores ...

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