How can I pass a paramater to MS Access query through the command line

How can I pass a paramater to MS Access query through the command line " C:\....\MSAccess.exe C:\....\MyAccess_database.mdb "

I dont understand the need for passing parameters thru command line. But by having a macro named mcrAutoExec with openquery command and your queryname which will open your query will prompt for a parameter if your query is designed in the following manner.



SELECT Field1name, Field2name FROM TableName

WHERE (((Field1Name)=[enter value for Field1Name]));