Defining Combo Box values...

  • Thread starter Thread starter Mojtaba Danai
  • Start date Start date
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
 
Back
Top