Would someone please show me how to execute a parameter query in Access
2000, passing 2 values and returning the results to an ado recordset.  Thank
you.

Good morning:

Would someone please show me how to execute a parameter query in Access
2000, passing 2 values and returning the results to an ado recordset.  Thank
you.

It's an ASP example but the code would essentially be the same for VB:

HOWTO: Call a Parameterized Query to an Access Database with ADO
http://support.microsoft.com/default.aspx?scid=kb;en-us;200190

Microsoft MVP (Visual Basic)

Dim cmd As ADODB.Command
Dim rst AS ADODB.Recordset

cmd.ActiveConnection = _
  "provider=SQLOLEDB.1;password=nemisis;persist security
info=true;user id=sheldon," & _
  "initial catalog=EAC;data source=desktop"
cmd.commandType = adCmdText

cmd.CommandText = "Select * from passwd where name=? and
passwd=?"
Set rst = cmd.Execute(Parameters:Array(username, password))

username and password are the parameters to be passed in
the SQL Query.

Hope this helps.