UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Open Form control, subform to subform    
 
   
costerma
post Sep 13 2008, 09:07 AM
Post #1

UtterAccess Addict
Posts: 136
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?
Go to the top of the page
 
+
Alan_G
post Sep 13 2008, 09:11 AM
Post #2

Utterly Yorkshire and Forum/Wiki Editor
Posts: 15,895
From: Devon UK
Can you post the code you're currently using...........
Go to the top of the page
 
+
costerma
post Sep 15 2008, 12:39 PM
Post #3

UtterAccess Addict
Posts: 136
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
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th June 2013 - 05:11 AM