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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Value error in a Subform 0
Query Parameter using multiple options 0
Form question: Simplest way to bring in a query result that is notthe record source into a form? 3
Is it possible to pass an operator from a form to a query limit? 2
Run Update Query From Form 0
Passing values from a form to a query 9
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Option Buttons to Pass Criteria to Query 6

Back
Top