Sep 13 2008, 09:07 AM
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?
Sep 13 2008, 09:11 AM
Can you post the code you're currently using...........
Sep 15 2008, 12:39 PM
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
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here