Bill S.
I assume you are looking for some clarification to this but not sure what your questions might be. Place a text box in the main form and name it: "txtSynch". Then in the On Current event of the top/master subform, add code like:
Me.Parent.txtSynch = Me.NameOfPrimaryKeyField
Then set these properties of the bottom/child subform
Link Master: txtSynch
Link Child: NameOfYourForeignKeyField
Duane Hookom
MS Access MVP
> To: MS_Access_Professionals@yahoogroups.com
> From: pdk444444@yahoo.co.uk
> Date: Tue, 18 Sep 2012 11:57:26 +0100
> Subject: Re: [MS_AccessPros] Re: sub form from datasheet view
>
> Hi Clive
>
> OK not to worry.
>
> I have replied to Duane asking for clarification - please feel free to chip in again at any time.
>
> cheers
>
> Phil
>
>
>
> ________________________________
> From: Clive <zctek@aol.com>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Tuesday, 18 September 2012, 9:40
> Subject: [MS_AccessPros] Re: sub form from datasheet view
>
>
>
> Sorry Phil,
>
> I just checked on my example and it had a single
> record on the main form, doh!
>
> Go with Duane's solution.
>
> Regards, Clive.
>
> --- In mailto:MS_Access_Professionals%40yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
> >
> > You could try two subforms on an unbound main form. The top subform could be the parent/master with the bottom subform displaying the child records. I typically use a hidden text box on the main form to store the primary key value from the master subform and then use the Link Master/Child properties to keep everything in synch.
> >
> > Duane Hookom
> > MS Access MVP
> >
> >
> > > To: mailto:MS_Access_Professionals%40yahoogroups.com
> > > From: pdk444444@...
> > > Date: Mon, 17 Sep 2012 18:08:11 +0100
> > > Subject: Re: [MS_AccessPros] Re: sub form from datasheet view
> > >
> > > Hi Clive
> > >
> > > I tried this but it says that if a form contains a subform then it can't be viewed in continuous forms mode?
> > >
> > > Phil
> > >
> > >
> > >
> > >
> > > ________________________________
> > > From: Clive <zctek@...>
> > > To: mailto:MS_Access_Professionals%40yahoogroups.com
> > > Sent: Monday, 17 September 2012, 17:11
> > > Subject: [MS_AccessPros] Re: sub form from datasheet view
> > >
> > >
> > >
> > >
> > >
> > > Hi Phil,
> > >
> > > It will not work with the MainForm in DataSheeetView
> > > because you will not be able to see a SubForm.
> > > In addition you will not be able to see/access any
> > > CommandButtons on the MainForm in DatSheetView.
> > >
> > > Instead, make the MainForm ContinuousForms, then you
> > > will be able to see the SubForm in FormView or DatasheetView.
> > >
> > > Hope that helps.
> > >
> > > Regards, Clive.
> > >
> > > --- In mailto:MS_Access_Professionals%40yahoogroups.com, "pdk444444" <pdk444444@> wrote:
> > > >
> > > > I have a form (single record) with a subform below showing multiple records relating to the main form record - standard stuff.
> > > >
> > > > I want to view the main form in datasheet view and have the subform visible each time I select a different record in the main datasheet and for it to act in exactly the same way as it does in form view (ie I can add, delete and update it's records as well as view them)
> > > >
> > > > I am trying to display the subform via an embedded macro in the 'on current' property but am not getting the correct sub records
> > > >
> > > > Any help would be appreciated.
> > > >
> > > > Phil
> > > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar