hardik_088
Registered User.
- Local time
- Today, 16:56
- Joined
- May 31, 2011
- Messages
- 82
Hi ,
I am getting problem with record source property.
suppose i have one form that contains 4 combo box and i am trying for cascading combos.
first combobox is country_name from table1
second combobox is province_name from table1
third combobox is department_name from table2
forth combo box is First_name from table2
when i select record source from table1 then first two combo box are getting value but third and fourth i am getting #name error
and when i select record source from table2 then third and fourth working but first two getting #name error. so i listen that you can do by JOIN but how i dont know can anybody tell me how to do?
thanks a lot
I am getting problem with record source property.
suppose i have one form that contains 4 combo box and i am trying for cascading combos.
first combobox is country_name from table1
second combobox is province_name from table1
third combobox is department_name from table2
forth combo box is First_name from table2
when i select record source from table1 then first two combo box are getting value but third and fourth i am getting #name error
and when i select record source from table2 then third and fourth working but first two getting #name error. so i listen that you can do by JOIN but how i dont know can anybody tell me how to do?
thanks a lot