Query from text box value

  • Thread starter Thread starter EMILYTAN via AccessMonster.com
  • Start date Start date
E

EMILYTAN via AccessMonster.com

My idea is create a query. The field set as the job number field and the
criteria i set is as
"[Forms]![WIPCategory]![txtC_WIPCategoryID]"
But it simply can't work...
I want to display this result to be in combo box
 
EMILYTAN said:
My idea is create a query. The field set as the job number field and the
criteria i set is as
"[Forms]![WIPCategory]![txtC_WIPCategoryID]"
But it simply can't work...
I want to display this result to be in combo box
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Don't use the quotes around the form control's reference. E.g.:

PARAMETERS [Forms]![WIPCategory]![txtC_WIPCategoryID] TEXT;
SELECT <column list>
FROM <table name>
WHERE <column> = [Forms]![WIPCategory]![txtC_WIPCategoryID]

--
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/AwUBRl+VqYechKqOuFEgEQLJPACg+sHb+fYULTvKol/3YghMcIxj01AAoO8m
qYhqDIx+/LHOLl7OtAtajaLU
=U6u/
-----END PGP SIGNATURE-----
 
Where should I put this statement
My idea is create a query. The field set as the job number field and the
criteria i set is as
"[Forms]![WIPCategory]![txtC_WIPCategoryID]"
But it simply can't work...
I want to display this result to be in combo box
Click to expand...

Don't use the quotes around the form control's reference. E.g.:

PARAMETERS [Forms]![WIPCategory]![txtC_WIPCategoryID] TEXT;
SELECT <column list>
FROM <table name>
WHERE <column> = [Forms]![WIPCategory]![txtC_WIPCategoryID]
Click to expand...
 
Back
Top