PDA

View Full Version : Solved: I want a combo box to limit a combo box



hatched850
11-14-2006, 01:58 PM
In a form I have a combo box to select a county the next combo box is the city. I have a table with the counties and their cities. I want to make the city combo box in my form list only the cities for the county that was already selected. Does this make sense?

:help

as always you guys are the greatest!!

hatched850
11-14-2006, 03:02 PM
I fixed it myself!!!! Are you guys not proud. Right clicked on property field for the look up I was trying to limit and went to the query and fixed set the criteria to [Forms]![community colleges]![District]. It works great.