Defining Combo Box values...

Article View: comp.databases.ms-access

Article #216

Back to comp.databases.ms-access Previous Next

#216

From: Mojtaba Danai
Date: Tue, 01 Jul 2003 17:08

29 lines
2301 bytes

Hi

I am trying to make a From with two Combo Box in it. I wish to have the
following behaviour in the form;

When I choose a value from the first Combo Box (Combo1), which has its Row
Source a table, the values presented on the second Combo Box (Combo2) be
based on Combo1.
So if I change the value in Combo1, the list in Combo2 has to changed.

These values for these two combo boxes have to be read from two tables,
which have one-many relation. That is why the values of Combo2 is depend of
values form Combo1.

Does any body know, how I can do this? In Row Source properties for Combo2
or Control Source?
How the SQL query looks like?

for exampel: select col2 from tab1, tab2 where table1.col1=
Froms!Myform!MyCombo.Column(0)
But the above SQL does not work!

Hope that some body can help

Thanks in advance

Regards
Mojtaba Danai
Ericsson Ireland

Technical Details

Message-ID: <bdsf66$70a$1@newstree.wise.edt.ericsson.se>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.algonet.se!'newsfeed1.telenordia.se'!algonet!uab.ericsson.se!erinews.ericsson.se!news.ericsson.se!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 1163bd,e5f3c0efd41b59a6,start
X-Google-Attributes: gid1163bd,public
X-Google-Thread: 11387c,e5f3c0efd41b59a6,start
X-Google-Attributes: gid11387c,public
X-Google-Thread: ff0ac,e5f3c0efd41b59a6,start
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 10bb27,e5f3c0efd41b59a6,start
X-Google-Attributes: gid10bb27,public
X-Google-ArrivalTime: 2003-07-01 10:10:21 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.algonet.se!'newsfeed1.telenordia.se'!algonet!uab.ericsson.se!erinews.ericsson.se!news.ericsson.se!not-for-mail
From: "Mojtaba Danai" <mojtaba.danai@eei.ericsson.se>
Newsgroups: comp.databases.ms-access,dk.edb.database.ms-access,microsoft.public.access.formsprogramming,microsoft.public.access.queries
Subject: Defining Combo Box values...
Date: Tue, 1 Jul 2003 18:08:48 +0100
Organization: Ericsson
Lines: 32
Message-ID: <bdsf66$70a$1@newstree.wise.edt.ericsson.se>
NNTP-Posting-Host: v20115e.eei.ericsson.se
X-Trace: newstree.wise.edt.ericsson.se 1057079303 7178 159.107.165.94 (1 Jul 2003 17:08:23 GMT)
X-Complaints-To: abuse@ericsson.se
NNTP-Posting-Date: Tue, 1 Jul 2003 17:08:23 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106