Cascading Combo to Subform MultiEntry

[thehorse]

First, thanks to all the experts on this site for your time and help. I've learned more in the last month reading the threads than I could from any book.

Now to my current issue:

I'm working on a form/subform. The form has 2 cascading comboboxes, [PicState] and [PicLoc]. PicLoc uses the state selected in PicState to source locations. The location from PicLoc then populates a subform with information about the city. Using info from this site, I finally got this operation to work. HOWEVER, here's my problem: the subform lists information for all cities of the same name (e.g., Kansas City MO and KS). It is not disginguishing the PicState.

Here's how I currently have it built:
[PicState] RowSource = state
[PicLoc] RowSource = location and state with Group By location
[Subform] link master = PicLoc, child = Location

Thanks for any/all suggestions.

 

[PHV]

master and child may be set with several field names.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[thehorse]

Got it.

I simply modified [Subform] to:

link master = PicState;PicLoc, child = State;Location

Works like a charm. Thanks.