Updating a combo from another combo

[keiath]

Hope someone can help

I have 3 tables;- Landlords Details, Resident Details and Case File

I created a form based on Case File.

I then made a combo block that looks up Landlord details the shows me the 'Block Number'

I then made a Combo box that i want the first combo (block number) to only list all residents that are in that block so that i can then select the resident I want, i



in the first combo after up date i have

Private Sub Combo95_AfterUpdate()
Me.Combo107.Requery
End Sub


107 refers to the second combo

in the second combo box i went to Data row source

Landlord Details - Block number
then
Leaseholder Details - Resident Number - in Criteria [Forms]![Case]![Combo95]

but that doesnt seem to work what am i doing wrong?

[alansidman]

Here is a link on how to build cascading combo boxes

http://www.fontstuff.com/access/acctut10.htm

[keiath]

I should have said i am running Access 2007-2010 and i am not sure that actually solves the problem

[CJ_London]

here's a link to another way of doing it

http://www.access-programmers.co.uk/...d.php?t=275155

[keiath]

this is Solved