Refresh Datasheet view - Query

[Shallo9]

Hi

I've got a table with Two Columns Col A & Col B
Col A is linked to a sub table called list
Col B is linked to a different table as wel

COl A - has for Ex: COLOR, Drink, Phone

COL B should refresh depending on Col A's Value ...For Ex if I select COLOR in Col A Col B should Drop down only Colors like Red Green Blue...Etc

It does it perfectly but shows everything in column B

I am sorry If I've confused any of you...

Thanking you in advance

 

[vbaInet]

Are these combo boxes in a Single form, Continuous form or Datasheet?

How did you set up Combo A to filter Combo B?

 

[Shallo9]

Are these combo boxes in a Single form, Continuous form or Datasheet?

How did you set up Combo A to filter Combo B?

Yes they are combo boxes...

Table A has list of all the Main categories like Color,Drink....
Table A
ID strMainCat
1 Color
2 Drink
3 Phone


Table B has two columns Main Category (linked to table A) and sub category
ID StrMainCat strSubCat
1 Color Red
2 Color Blue
3 Color Green
4 Drink Coffee
5 Drink Tea
6 Drink Cola

Created 3rd table C

ID strMainCat(linked to table A) strSubCat (linked to Table B)

created a subform using tbl C and want to view it in datasheet view.

Hope that is clear...

 

[vbaInet]

You can't do this easily in a continuous form or in a form in Datasheet view.

Look at the Continuous Form Combo example in the following link:

http://www.databasedevelopment.co.uk/examples.htm