parameters

can access pass parameters?

[J Staniforth]

Do you mean that you have created a parameterised query in Access and want to implement it through VB code?
If so then use a Querydef and it's parameters properties to pass the param values before executing it to get the results.
eg
Dim paramQ As QueryDef
Dim aRS As Recordset

Set paramQ = CurrentDb().QueryDefs("query")
paramQ.Parameters("ReqDate") = #12/3/99#
Set aRS = paramQ.OpenRecordset

Regards.