limit the content of one combo box based on another

[Guest]

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;

 

[Allen Browne]

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