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]
Tidak ada komentar:
Posting Komentar