I have as search form that when using combo boxes, filters out my records and displays then into a searchsubform. I've been try to use a launch command from that searchsubform that will open my master form which also contains filter commands with a imbedded subform as well. However, when I tell the wizard to use the ID field in the searchsubform to open up the masterform with those records displayed, it gives me everything. One thing I noticed was that the ID field in the master subform does not display when using the wizard. What am I missing?

Can you post the code you're currently using...........

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Form3"

stLinkCriteria = "[Ship to Num]=" & Me![ID]
DoCmd.OpenForm stDocName, , , stLinkCriteria


The problem is [Ship to Num] is in the subform called subfrm_Master of the the master form labled "Form3"

I tried stLinkCriteria = "[subfrm_Master]!][Ship to Num]=" & Me![ID] and it just opens Form3 dispplaying all records