Is there any way to use DCmd.OpenForm to open a Single View form showing all the matching Components on the subform.
For example, I have an Orders Form that has a subform containing component numbers. I want the Orders form to come up for say 10 records if there are 10 Orders with the component number that I'm looking for. Here is my code which doesn't work:
stDocName = "Orders"
stLinkCriteria = "[Orders].[Orders Subform].[Component #]=" & "'" & Me![Component #] & "'" 'no worky
DoCmd.OpenForm stDocName, , , stLinkCriteria