Form with two subforms open WHERE Condition

[raphael99]

Hi
I have a form (nameform) with two subform (subform A)(subform B) based on two different queries.
All is fine when run it.
I'm tryng to open "nameform" from another form (FormPrincipale).
To do that I'm using macro command on a button click event with WHERE Condition is ="[ID]=" & [ID].
The form (nameform) opens but I can't get any data on both subforms.
How can I open "nameform" showing the both subforms diplaying results?
Thanks

 

[CJ_London]

have you set the linkchild/linkmaster properties to both subform controls?

 

[raphael99]

Yes they are linked

 

[mjdemaris]

You could try using tempvars. I am in a similar situation, experimenting with tempvars.

 

[vbaInet]

You can also use the WHERE parameter of the OpenForm method described here by pbaldy:

http://www.baldyweb.com/wherecondition.htm

 

[raphael99]

NeverMind. I got my head out of world...
Mistaken to add the proper table ID.
Linking Master/child in Form/Subforms works very well.
Thanks for support :banghead: