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