thank you Ridders52,
And not always your way is the best to design database, try to be open minded
I never said it was. All I said was I have a system which does work and according to you, yours didn't ... but from your last post it does again....????
You asked for advice. I offered it. Up to you whether you take my advice or not
Uuu 10 nested subforms? O wow and you have to click again and again to expand them one by one? And input data? These are datasheet views?
Do you have any examples, i am interested to see this. I can learn something new.
I didn't say that either. I've just checked
here and in fact you can 'ONLY' have up to 7 nested subforms (not 10)
I do have at least 3 levels of nesting in a few RARE cases but those are NOT datasheets
Nesting forms is not the same thing as using subdatasheets..
I rarely use subdatasheets as they are generally confusing for end users & cause a performance hit. In fact, I had already suggested you got rid of them
My Customer wants to have all in one main form. And i have this for him.
A lot of subforms based on juntion tables and comboboxes. You can easily add all atributes and not clicking all the time to open another separete forms with another subforms. All in one place - very user friendly. And also working already one year without complaints.
Fine by me. Its your database. Do what your customer wants as long as it works
Ok returning to issue:
I afraid that filtering can be change only via VBA - after selecting record on one subform i have to change recorset on subform and requery it. and thanks to it i can see expected result.
But you've solved that again have you?
Good luck with your project