Defining Combo Box values...


M

Mojtaba Danai

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top