Cao said:
Hii.. everybody
I want to use comboboxes on a form, which are referenced in the
criteria section of the query, so that the query returns record for the
selected value in combobox.How this reference can be set?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Set up a PARAMETERS clause in the SQL view of the query:
PARAMETERS Forms!FormName!ComboBoxName Long;
SELECT ...
FROM ...
WHERE column_name = Forms!FormName!ComboBoxName
Change the FormName and ComboBoxName to whatever your form and combo box
names are. Change the data type Long to whatever your ComboBox's data
type. Use your table's column name in place of column_name.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQmUWJYechKqOuFEgEQJQvwCeMMNG84jFBkPc0giIy8H94eNglEwAn0fp
yQm48HVj/YnvEo0f3k7Mu3O1
=ekCK
-----END PGP SIGNATURE-----
