Stored Parameter Query in Access

[Kurzo]

I read that I can used a stored query in Access with:

Dim cn As New ADO.Connection

cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyDB.mdb"
cn.Execute "YourQueryName"

What if my query needs a variable from a vb form to run the query?

thanks all