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: MS_Access_Professionals@yahoogroups.com
> From: pdk444444@yahoo.co.uk
> 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@aol.com>
> To: MS_Access_Professionals@yahoogroups.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]
Tidak ada komentar:
Posting Komentar