Passing parameters to Access query from VBA

[xargon]

Hi everyone,


I am an Access n00b.


I have been trying this for hours and to no avail. I do not know why
this should be so difficult!


I have a query in Access say something simple like:


Select * from Employees


All I want to do is pass it a parameter like:


Select * from Employee where Name = "My name"


How can I achieve something so trivial from VBA? I was hoping that a
runSQL command with the query name and the WHERE clause would do it,
but apparantly not.


Thanks!
xarg