Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cascading Combo to Subform MultiEntry

Status
Not open for further replies.

thehorse

Programmer
Oct 1, 2004
14
US
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.
 
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
 
Got it.

I simply modified [Subform] to:

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

Works like a charm. Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top