Hi,

Currently, I'm having a combo box to find records according to the first name. Now I would like to have two combo boxes, where in one combo, it will have the alphabet fields(A-Z).So when the user choose A, the other combo box must filter all the first name starting with 'A', then when clicked o.k, it will show the first name starting with 'A' records. How to do this kind of filteration?
Thank you.

Here's another solution from Northwind ...

Open the customer phone list ....

HI,

I want only two combo boxes(drop down list) next to each other. When you click A in the first combo box, then the second combo box must have all the names starting with A (filtered) so that the user can click on the users name to view the form.

Thanks

Check this out ...

frmA -- With criteria in combo box ...

Just change the criteria in a row source of combo17 to be ...

Like [Forms]![frmA]![Combo16] & "*"

And the row source in Combo16 would be from

A to Z ...

Hi,

I did the combo box filter based on other combo box, so when the user choose the name , it will display the form where the name is, but now I couldn't add any record in the form as it is telling that "You cannot add or change a record because record is required in tblAlphabet". Why is it so?Please help me out. Thanks