A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How can I create a form with a cascaded lookup?



 
 
Thread Tools Display Modes
  #11  
Old June 2nd, 2010, 11:44 PM posted to microsoft.public.access
Wingnut[_2_]
external usenet poster
 
Posts: 6
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 02:18 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.