Query by form

[Daniel Biancuzzo]

I am using Microsoft Access 2000 and am trying to pass a contol
(specifically a combo box on a bound form) to a parameter query using that
control. When I enter the sting [forms]![form name]![combo box] in the
criteria field of the query design view, Access simply displays the string
in the pop up window asking for the parameter.

Is there a way to pass this value to my parameter query?

 

[Ki Yi [MS]]

Hello,

Parameter query is referencing a control on a form so this form must be
opened before executing the query.

FYI:

ACC2000: How to Use the Query by Form (QBF) Technique WGID:147
ID: 209645.KB.EN-US
http://support.microsoft.com/default.aspx?scid=kb;en-us;209645

ACC2000: Query by Form (QBF) Using Dynamic QueryDef WGID:147
ID: 210242.KB.EN-US
http://support.microsoft.com/default.aspx?scid=kb;en-us;210242

Regards,

Ki Yi
Microsoft Support

This posting is provided AS IS with no warranties, and confers no rights.