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

Kamis, 22 Oktober 2015

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

Celal-

Thanks a lot. But I couldn't open the second link with examples from China. Is it possible to upload that example to group folder? Thanks again.

Best Regards,

Kevin

From: c.ozturk@nova-trade.com [MS_Access_Professionals]
Date: 2015-10-22 23:06
To: MS_Access_Professionals
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