limit the content of one combo box based on another

I have 3 tables, project, site, and sample. In tblSample the fields Project
and Site look-up their respective tables. tblSite has a field Project that
looks-up tblProject.
I want to make a form with tblSample where the user selects Project then the
Site field is limited to the sites of the selected project.

Here's the current non-working code. Thanks.
SELECT tbl_Site.Site_Name, tbl_Site.Project1 FROM tbl_Site INNER JOIN
tbl_Sample ON tbl_Site.Site_Name=tbl_Sample.Site_Name WHERE
(((tbl_Site.Project1)=Forms!test!Project)) ORDER BY tbl_Site.Site_Name;

See:
Limit content of combo/list boxes
at:
http://www.mvps.org/access/forms/frm0028.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"andie" wrote in message
...
I have 3 tables, project, site, and sample. In tblSample the fields
Project
and Site look-up their respective tables. tblSite has a field Project
that
looks-up tblProject.
I want to make a form with tblSample where the user selects Project then
the
Site field is limited to the sites of the selected project.

Here's the current non-working code. Thanks.
SELECT tbl_Site.Site_Name, tbl_Site.Project1 FROM tbl_Site INNER JOIN
tbl_Sample ON tbl_Site.Site_Name=tbl_Sample.Site_Name WHERE
(((tbl_Site.Project1)=Forms!test!Project)) ORDER BY tbl_Site.Site_Name;