Help Limiting Records Using Combo and List Boxes

[goldenvision]

Download the sample database and print off the table before reading this question.
------------
Is it possible to do this.

1
In cboSURNAME the only options available to select are
Edwards
Smith
Stimpson
Todd

After entering Edwards

2
In cboFIRST the only options available select are
"BLANK" & "P"

After selecting "P"

3
The only options available in listADDRESS are
"9 pimbo lane" & "34 dixie street"

-------------
I know how to achieve 1 using GroupBy and I think I know how to achieve 2 selecting the Leftmost character and using query criteria

But I am stuck with the rest. This would really get me out of a hole.

 

[Mile-O]

Search the forum for cascading combo boxes