How can ask a query to put a parameter into different fields.

S

Scott

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?
 
M

MGFoster

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?
Click to expand...

-----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-----
 
L

Lord Kelvan

basically you have to have a different check box for each field and
the releate that check box back to each field. if you want users to
only select one box then just use an on change event that disables all
other boxes when a uses clicks on a combo box.

Regards
Kelvan
 
Top