limit the content of one combo box based on another

  • Thread starter Thread starter Guest
  • Start date Start date
G

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;
 
Back
Top