Mar 18 2005, 11:54 PM
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?
Mar 19 2005, 12:12 AM
Here's another solution from Northwind ...
Open the customer phone list ....
Mar 21 2005, 01:26 AM
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.
Mar 21 2005, 01:35 AM
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 ...
Mar 21 2005, 03:53 AM
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
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here