Subforms limitation

[alinagoo]

Hello Dear
I faced with a unpredictable problem in Access 2007!
Please help me.

I want to link 5 combobox's from main form to 5 relevant fields in the
subform but i could do this just for 3 of them!
Access does not allow me to have more than 3 links(child links and master
links).

Do you have any solution?

Thanks in advanced

[TheSmileyCoder]

Are you sure? Im 99% sure I have done 4 links in some applications in 2003 (of course 2007 could be different).

The other alternative, is to create a filterstring in your main form, and then apply that to your subform. There are several posts about that in this forum.

[alinagoo]

Are you sure? Im 99% sure I have done 4 links in some applications in 2003 (of course 2007 could be different).

The other alternative, is to create a filterstring in your main form, and then apply that to your subform. There are several posts about that in this forum.

Yes you are right
But
Another simple way is dragging table or query from navigation pane to the form in design mode!
This way gives you just datasheet view with filtering capability! I used this solution.

Best wishes for all