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?

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

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

Top