Still in the Combo Box Issue

[tarek_ta2ta2]

hi great people

thanks for the help i almos reach my goals

i have a proplem i hope it's a little on

i have three cascading combo box which working great

when selecting value from the first comb the second combo load the values

and the same for the second when select value the third combo load values

the problem is:

if i go back again to the first combo if i check the third combo it still keep the values from the last selection

any ideas

 

[Oldsoftboss]

On the afer update event of the first combo box simply put:

Me.Combo3name = Null

Dave

 

[tarek_ta2ta2]

Not what i mean

thanks man

but i already do this and it clear the combo box

but if you click the combo box you will find the data there still exist fro the previous selection

look ...
before u select combo box 1 if you click on combo box 2 you will not find any thing

so because i have threee combo
the second one depend on the first one
and the third one depend on the second one

so when i select the combo 1 and then the second nd then the third

when i come back again to one and select from it

before i select from the second if i go to the third i will find the data still there

and i don't wanna do that i want when go back to one to select reset the combo 3 two

 

[missinglinq]

You need to reset the RowSource of the third combobox. In the AfterUpdate event of the first combo box place:

ComboBox3.RowSource = ""

 

[tarek_ta2ta2]

sorry my friend ..not working too

i put in the first combo the following
Private Sub cboMake_AfterUpdate() 'First Combo
Me.cboModel = Null 'Second Combo
Me.cboGrade = Null 'Third Combo
Me.cboGrade.RowSource = "" 'Third Combo
Me.cboModel.Requery 'Second Combo

and in the second combo
Private Sub cboModel_AfterUpdate()
Me.cboGrade = Null
Me.cboGrade.Requery to get the third combo data

but it not work too

kindly have alook in my database

 

[khawar]

I told you previously in some other thread that you have to put all your models in a single table whether it is toyota or bmw

i have modified table structure and included both in one single table some other changes have also been made and you can see how easy it is to manage cascading combo box with it

No need to change row source every time only fixed row source will works in all conditions


Regards

Khawar

 

[tarek_ta2ta2]

See what i sent

thanks for ur support

but i think u didn't see the last version i sent

i made lot of modification ... kindly review it and see the different