ACCESS FEED: Re: [MS_AccessPros] Using Report as a subform in forms.

Minggu, 01 November 2015

Re: [MS_AccessPros] Using Report as a subform in forms.

Kevin-

No. You can use a form as a subreport in a report, but you cannot use a report as a subform in a form. If you don't want the user to be able to enter data, set Allow Updates, Allow Additions, and Allow Deletions all to No for the form.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Nov 1, 2015, at 11:18 AM, zhaoliqingoffice zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Crystal-

So It is ok to put subReport in forms,right? I intend to prevent user from entering things. Wait for your reply,Thanks.

Best Regards,

Kevin

在 "crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2015年11月1日下午5:53写道：

Hi Kevin,

you cannot use a subreport to enter information.

You can, however, create a new blank form and copy the controls ~

be sure to set the RecordSource, LinkMasterFields, and LinkChildFields too

warm regards,
crystal

~ have an awesome day ~

On 11/1/2015 2:33 AM, zhaoliqingoffice zhaoliqingoffice@163.com [MS_Access_Professionals] wrote:

Dear All-

Is it possible to use report （e.g. rptHotelDetails） as subform in main forms? Thanks

Best Regards,

Kevin