Passing value via a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi guys
Here is my question

I have a query an Access with criteria on one of the fields as "Form.form1.county.value"...
Now, I have a form in VB that runs that query (Docmd.openqury......

Is there a way I can specify what value to send to the query via the (Docmd.openqury.....

I would appreciate any help...
Thanks
 
The QueryDef Parameters property should do what you need.

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...
 
Back
Top