Cascading Combos with subform problem

[pikou]

Hello to all !
I have this db where i wantto include 4 and if possible 5 cascading combos where the user can select records from a table and view them in a subform which is in datasheet view.
All is going well until i try to add the 4th combo.Then when i select the 4th combos selection the subform displays nothing.
If someone could point me to the right direction i would be most thankful.
I have attached the db.
Thx for all replies

 

[RuralGuy]

I don't think you are utilizing the Link Master/Child Fields correctly. I'm pretty sure the LinkMasterFields should point to controls/fields on the MainForm. The way you are doing it why not just replace the RecordSource of the SubForm rather than the MainForm. Then no filters or LinkFields needed.

 

[pikou]

Yes i see oyur point but i cannot seem to find a proper way to implement this.
Any tips perhaps ?

 

[RuralGuy]

It really depends on what you are trying to achieve in the end. There is nothing wrong with replacing the RecordSource of the SubForm with each ComboBox. Try commenting out all of the code you have except the SQL string and replace the SubForm RecordSource instead of the MainForm and see if that achieves what you want. Leave the LinkMaster/ChildFields = "" and no filters and test it.

 

[pikou]

I am trying to give the user the ability to select the criteria from the combo's and have the records that fit that description appear on the subform.
The thing that i do not get at all is why does this approach work fine up until the 3rd combo where all the selections are made and the records are dispalyed just fine and when i add the 4th combo it appears to locate the records that i want but only for a flash of a second and then it leaves me with an empty subform.
Anyone else any thoughts on this plz?

 

[pikou]

No one any thoughts on this any suggestion at all?
I am really stuck on this and i have the feeling that the solution is right in front of me but i cannot grasp it.

 

[pikou]

Come on guys someone must have some ideas on this problem of mine.
Come on VBA gurus come out , come out whereever you are .......

 

[pikou]

Well i have tried anything including Rural's thoughts on the matter and still nothing.
This cannot be right I mean i should have found something up to now at least what is causing the problem.
Is there truly noone that can at least take a look at the problem?