Scott said:
I have a query that has multiple yes/no fields. Can I run a form to enter a
parameter into one of the fields and then run the query?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
The parameter would have to be a separate field.
PARAMETERS Forms!FormName!FormControlName Text;
SELECT col_1, col_2, col_3,
Forms!FormName!FormControlName As TheParameterField
FROM table_name
WHERE <criteria>
or use the parameter as a criteria:
WHERE col_3 = Forms!FormName!FormControlName
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBSMg6PIechKqOuFEgEQKKQACePvgePQNwmDHaGpAhIFLIOYtLQK4AoLhC
+gnxbX2lsqSrchTIO6pnGs/1
=iSVV
-----END PGP SIGNATURE-----