Thank you, Mr. Hookom and Mr. Mosca.
Your combined suggestions will allowed me to put a stake in this one.
Thanks,
Terryomsn
--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
>
> Terry,
>
> Sometimes you have to be smarter than Access and just type in the fields/controls used to link master/child. I often create main forms with no record source and use a control name in the Link Master property.
>
> Duane Hookom
> MS Access MVP
>
>
>
>
> To: MS_Access_Professionals@yahoogroups.com
> From: terryomsn@...
> Date: Fri, 8 Jul 2011 22:02:25 +0000
> Subject: Re: [MS_AccessPros] Synchronizing a Form and Sub-Form (Access 2003 or 7)
>
>
>
>
>
>
> Thanks, Bill.
> I gave your suggestion a shot and looked at the sub-form's properties. Both the master and child properties were null. However, when trying to pull down values in either of the two properties, I received a "cannot build a link between unbound forms."
> I'm wondering if Access is trying to tell me that query-based forms can't participate in the Master-Child linkage?
> Terryomsn
>
> --- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@> wrote:
> >
> > Terry
> >
> >
> >
> > Just to jump out there without doing too much effort <grin>...
> >
> > Have you made sure you sub form is linked to your main form?
> >
> > 1. Open the main form in design view.
> >
> > 2. Click on the sub form control and make sure the master and child links
> > are set up properly.
> >
> >
> >
> > Regards,
> >
> > Bill Mosca,
> >
> > Founder, MS_Access_Professionals
> >
> > That'll do IT <http://www.thatlldoit.com/> http://thatlldoit.com
> >
> > MS Access MVP
> >
> > <http://mvp.support.microsoft.com/profile/Bill.Mosca>
> > http://mvp.support.microsoft.com/profile/Bill.Mosca
> >
> >
> >
> >
> >
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Terry Olsen
> > Sent: Thursday, July 07, 2011 6:22 PM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] Synchronizing a Form and Sub-Form (Access 2003 or 7)
> >
> >
> >
> >
> >
> > I apologize in advance for the length of this message. I've been trying to get
> > it work for a bit.
> >
> > Functionality Needed
> > I need a form that will give me the ability to select a RunID; the form should
> > have a sub-form that displays selected columns for all table2 records with
> > TripID that also have a table1.RunID equal to the selected (from the combo on
> > the form) RunID.
> >
> > Current Status
> > I have the form working.
> > I have the sub-form working.
> > Currently, the form and sub-form are operating independently. I can select the
> > RunID. The sub-form is displaying all records as there are no criteria being
> > passed to the sub-form.
> > What I don't know how to do is synchronize the sub-form query results for the
> > combo box selected RunID from the form.
> > I've found all Table 1 TripIDs with the same RunID by creating a query using the
> > Query Design tool, and joining Table 2 to Table 1 by TripId and using a
> > hard-coded RunID as a query criterion.
> >
> > Background Info
> > Table 1 (tblCurrentRunsWithTripsFromXMLTransform)
> > RunID - Number data type
> > TripID - Number data type
> > Table2 (tblCurrentOrcaXMLTrip)
> > TripID - Number data type
> > TripName - Text data type
> > PeakFlag - Text data type
> > PeakFare - Text data type
> > Relationship
> > Each Table1.RunID will have one or more Table2.TripIDs (not defined in
> > Relationships).
> > Each Table2.TripIDs has only one Table1TripID (defined in Relationships)
> > The form contains only one Combo box that is populated by calling the
> > qryCurrentDistinctRunsFromXMLTransform query.
> > SELECT [qryCurrentDistinctRunsFromXMLTransform].[RunId] FROM
> > qryCurrentDistinctRunsFromXMLTransform ORDER BY [RunId];
> > The qryCurrentDistinctRunsFromXMLTransform query looks like this.
> > SELECT DISTINCT tblCurrentRunsWithTripsFromXMLTransform.RunId
> > FROM tblCurrentRunsWithTripsFromXMLTransform
> > ORDER BY tblCurrentRunsWithTripsFromXMLTransform.RunId;
> > The query that populates the sub-form is qryDisplayTripInfo
> > SELECT tblCurrentOrcaXMLTrip.TripId, tblCurrentOrcaXMLTrip.TripName,
> > tblCurrentOrcaXMLTrip.PeakFlag, tblCurrentOrcaXMLTrip.PeakFare
> > FROM tblCurrentOrcaXMLTrip;
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar