alvingenius
IT Specialist
- Local time
- Today, 09:06
- Joined
- Jul 10, 2016
- Messages
- 169
Hello
I've a main form with subform inside it
main form have only a combobox to filter the subfrm
and i wanna open this main form from a button on another form using vba code:
but i wanna use where condition too to filter the subform inside this mainform while openeing the mainform
the above code won't work of course because it will filter the mainform !, So, how to make it filter the subform inside the mainform
i hope you get it
--
Edit
Solution is here
I've a main form with subform inside it
main form have only a combobox to filter the subfrm
and i wanna open this main form from a button on another form using vba code:
Code:
DoCmd.OpenForm "mainform", acNormal, , "xYear= "& me.txtYear
but i wanna use where condition too to filter the subform inside this mainform while openeing the mainform
the above code won't work of course because it will filter the mainform !, So, how to make it filter the subform inside the mainform
i hope you get it
--
Edit
Solution is here
Last edited: