filtering for current record

[Access2000_JS1]

Hi,

I have two combo boxes where the first lists values in one table. On selecting one I want a second combo populated with records in another table where foreign key = primary key.

Obviously the query is

select location from client,location
where client.client = location.client

However I can not get to the current record.

Alternatively, I could populate a list programmatically on the afterupdate event but I am not sure how to do this or if this is the best way. Any advice would be most appreciated.

Thanks John.

 

[ejstefl]

Search Cascading lists, or click here.