ACCESS FEED: RE: [MS_AccessPros] Re: Sub continuous forms side by side

Jumat, 23 Oktober 2015

RE: [MS_AccessPros] Re: Sub continuous forms side by side

Thanks Bill, my posts didn't show up, thought there was something wrong

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, October 22, 2015 6:40 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Re: Sub continuous forms side by side

Hi Celal

I deleted your duplicate posts in this thread. Thanks for responding.

Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT http://thatlldoit.com
MS Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852

My Nothing-to-do-with Access blog

http://wrmosca.wordpress.com

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, October 22, 2015 8:06 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Sub continuous forms side by side

Hi Kevin,

I needed to do this sometime ago, guess I understand what you mean. Here are two examples that may help:

http://stackoverflow.com/questions/7861559/ms-access-sub-sub-forms

http://accesstips.datamanagementsolutions.biz/subsub.htm

The second one gives examples of 3 possibilities: Subdatasheet, Form Footer Section and Side By Side

Hope it helps

Celal

---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

Kevin-

It's possible to do the subforms "side by side" or on tabs, but you have to do a little work to keep the second subform synchronized. Put an unbound hidden text box on the outer form and use it to set the Link Master property of the second subform. In the Current event of the first subform, copy the link field value to that text box on the outer form. You might also have to do a Requery of the second subform to get it to automatically sync to the current row on the first subform.

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 Oct 22, 2015, at 2:23 PM, zhaoliqingoffice zhaoliqingoffice@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John-

Actually I want to put two subforms side by side, not in the footer.

Kevin

在 "zhaoliqingoffice zhaoliqingoffice@... [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2015年10月22日下午7:19写道：

John-

The main form is the GroupBooking,one of the subform is subBookingPart, by which I can divided the whole itinerary into different parts. Then the other subform is linked to subBookingPart, Called subServiceBooking. In this case, The main form contains a subform, and the subform contains another subform, and this may go on...

I hope I explain it clearly. Please help, John. Thanks in advance.

Best Regards,

Kevin

在 "John Viescas JohnV@... [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2015年10月22日下午5:52写道：

Kevin-

Why do you think you need to put one of the subforms in the footer? What is the relationship between the Record Source for the outer form and the Record Source in the two subforms?

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 Oct 22, 2015, at 12:13 AM, zhaoliqingoffice zhaoliqingoffice@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Dear All,

Is that possible to attach two sub continuous froms to the main form side by side, instead of putting one in the footer? Is there any example? Thanks in advance.

Best Regards,

Kevin