If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
How can I create a form with a cascaded lookup?
Nancy, I'm needing to do the same thing - did you ever find a solution to
this? I know this is an old thread. I know it is possible to create a drop-down check box list using a combo box and a look-up table, and select multiple values from it - but is there any way to link two such drop down lists so that the second is dependant on the first? I want to select multiple records from a combo box list of islands, and have a second combobox list to select specific places from each of the selected islands. Any help would be great! Thanks. "Nurse Nancy" wrote: they are definately both combo boxes,, in ms2007 you can create a multi-select combo box where you check the check boxes to select mutliple and there is an OK and Cancel Button on the drop down. I am using them as seach criteria for a query Here is the SQL behind the [Market Region Combo Box] SELECT [MARKET REGION TABLE].[Market Region ID], [MARKET REGION TABLE].[Market Region] FROM [MARKET REGION TABLE] ORDER BY [MARKET REGION TABLE].[Market Region]; And the values are 1 = Norther 2 = West Coast 3 = Southern 4 = East Coast 5 = Mid West 6 = Central What gets bound is the numeric values Here is the SQL behind the Market Combo Box SELECT [MARKETS TABLE].[Market ID], [MARKETS TABLE].Market, [MARKETS TABLE].[State ID] AS State, [MARKET REGION TABLE].[Market Region], [MARKETS TABLE].[Market Rank] AS Rank, [MARKET REGION TABLE].[Market Region ID] FROM [MARKETS TABLE] INNER JOIN [MARKET REGION TABLE] ON [MARKETS TABLE].[Market Region ID] = [MARKET REGION TABLE].[Market Region ID] ORDER BY [MARKET REGION TABLE].[Market Region], [MARKETS TABLE].Market; There are approx 300 Markets and each is assigned to a Region in the Market Table So for Intstance Los Angeles Market has a region = 2 (West Coaast) Does this help at all I want to be able to select West Coast in the Market Region Combo Box and only Regions in West Coast would be displayed in the Market Combo Box (which is also Multi Select) -- Nancy "Hans Up" wrote: Nurse Nancy wrote: I am still looking for any help anyone can give me on synching combo boxes that are multi-select. When you mention combo boxes, do you actually mean list boxes? The reason I ask is because I thought the multi-select property was only supported for list boxes, not combo boxes. Both the Knowledge Base article links you supplied are about list boxes. i found these posts,, and think they might help but don't know exactly how to tweak it to work for my needs of synching the combo boxes. http://support.microsoft.com/kb/827423 - how to store the list as a string http://support.microsoft.com/kb/135546 - how to use mulit-select to filter a form can anyone help me use this logic to synch my combo boxes? I'm lost, Nancy. If you actually have a *combo* box bound to an Access 2007 multi-valued field, perhaps the combo displays multiple selections. But I have no experience with that combination of features. WRT multi-valued fields, I am following (my understanding of) MVP advice ... don't use them. If you clarify your situation, perhaps someone can offer useful help. . |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Requerying a pop up form to display in the main form | Jennifer P | Using Forms | 13 | April 5th, 2005 06:59 PM |
automatically fill field with form information | Tina L. | Using Forms | 2 | January 14th, 2005 08:18 AM |
If I create a form with the wizard and later decide I need to add another field do I have to re-create the form? | Mister John Doe | Using Forms | 3 | January 2nd, 2005 07:17 AM |
How To Create Form with Tabs In Tabular Layout? | hylow | Using Forms | 1 | December 17th, 2004 01:02 PM |
open a form through a subform in access 2000 | Tammy | Setting Up & Running Reports | 12 | October 22nd, 2004 02:43 PM |