Hello

I'm trying to create a combo field that changes its options based on the value of the another combo field in the same record.  Is this possible

Options Tabl
Combo1       Combo
1                    
1                    
1                    
1                    
2                    
2                    
2                    
2                    

If I select "1" in combo box 1, I want options A, B, C, or D in combo box 2.  If I select "2" in Combo 2, I want E, F, G, or H

I'd appreciate any help i could get on this.  I know in Excel I'd use some sort of "thisrow" command string. Can I do this in Access

Thanks
Kyle B
(two days experience, running Access 2002