Using form values as criteria for query

[Guest]

I would like to run a query from a form where the query inherits the criteria
on display on the form. eg, if I am looking at invoice #1 in the form, I can
use a button to run a query which uses invoice # 1 as the query criteria.

Does anybody have some code I can use for this?

Thanks

 

[David Lloyd]

Richard:

The following KB article may be a good reference, depending on your exact
needs.

http://support.microsoft.com/default.aspx?scid=kb;en-us;304428

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I would like to run a query from a form where the query inherits the
criteria
on display on the form. eg, if I am looking at invoice #1 in the form, I
can
use a button to run a query which uses invoice # 1 as the query criteria.

Does anybody have some code I can use for this?

Thanks