Hi,

I have a table of Property Addresses, and a Table of Tenants within the
properties, and I am trying to build a table for maintenance issues
reported, populated from a form.

The first Drop Down list in the form is a straightforward lookup combo box
derived from the addresses table. SELECT Addresses.Property FROM Addresses;

The second drop down box should be populated with the name of tenants
currently
living in the property by using another lookup combo box with an SQL query
behind it, which currently looks like this, but doesn't work;

SELECT Tenants.ID, Tenants.[Last Name] FROM Tenants WHERE
Tenants.Property=[Property];

But this actually produces the whole list of tenants regardless of the
property
they are in! When I actually only want the names of the tenants currently
occupying the property. Somehow my statement is wrong!

What am I doing wrong?

Thanks!
Russell.