I have an Access Query that requires a user to enter an acct#. The query
then pulls all orders by that acct#. The query works fine in Access...But
now I am building a VB app and I am trying use the same query. My question
is how do I pass the Acct# from VB to the query?

Thanks

Dan

  ' declare DAO objects
  dim qdf as DAO.Querydef
  dim rs as DAO.Recordset

  ' open the query
  set qdf = dbAccountingDatabase.QueryDefs("GeneralAccounts")

  ' set the parameter
  qdf.Parameters("AccountNumber")="A12.09.09"

  ' recover the data
  set rs = qdf.OpenRecordset(dbOpenSnapshot, dbForwardOnly)

  ' etc

  ' Hope that helps

--