Working on access 2007. My database file is made on access2003.
I have 2 forms. (categories) and (Productlistsearch).
The Productlistsearch form contain a subform called "Products subform"
I want to open "Productlistsearch" from "categories" where CategoryID in "Products subform" = categoryid in categories.
I tried many syntax but unfortunately I didn't success.
This is my last method that I used.
Expand|Select|Wrap|Line Numbers
- Dim stDocName As String
- Dim stLinkCriteria As String
- stDocName = "Productlistsearch"
- stLinkCriteria = "Forms![Productlistsearch]![Products subform].Form![CategoryID]=" & Forms![categories]![CategoryID] & ""
- DoCmd.Close
- DoCmd.OpenForm stDocName, , , stLinkCriteria
THANK YOU
WASSIM S DACCACHE