Tabbed Subforms - reference

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This "should be simple" but I can't get it to work so any help would be
"greatly" appreciated.

I have a query that contains personal details (from tblClients) and details
of orders (from tblOrders) the query is qryBookings.

Each client can have many bookings and each booking can have many items.

I have created a main form [frmMainForm] with a number of tab controls -
Orders, Items, ect.

So,
[frmMainform] = John Smith
[tabbedSubform1] = Orders - select item 1 or 2 or 3 etc
[tabbedSubForm2] = Details of the item slected in SubForm1

I have tried creating a text box on the Main Form with the details of the
slection in Sub Form 1 but it will not appear in the Child List for the Sub
Form 2

I have tried using OnCurrent filter for Sub Form 2.

I'm stumped

My question is how do I get the second subform to be filtered by a selection
I make on the 1st.

Thank you so much for any help
 
tabbedSubform2 should be a subform or tabbedSubform1 - or use a button to
open a separate form, perhaps.
 
Thank you Susan

It works now - must be a bit slow this morning (with your help)


SusanV said:
tabbedSubform2 should be a subform or tabbedSubform1 - or use a button to
open a separate form, perhaps.
--
hth,
SusanV


MikeCCC said:
This "should be simple" but I can't get it to work so any help would be
"greatly" appreciated.

I have a query that contains personal details (from tblClients) and
details
of orders (from tblOrders) the query is qryBookings.

Each client can have many bookings and each booking can have many items.

I have created a main form [frmMainForm] with a number of tab controls -
Orders, Items, ect.

So,
[frmMainform] = John Smith
[tabbedSubform1] = Orders - select item 1 or 2 or 3 etc
[tabbedSubForm2] = Details of the item slected in SubForm1

I have tried creating a text box on the Main Form with the details of the
slection in Sub Form 1 but it will not appear in the Child List for the
Sub
Form 2

I have tried using OnCurrent filter for Sub Form 2.

I'm stumped

My question is how do I get the second subform to be filtered by a
selection
I make on the 1st.

Thank you so much for any help
Click to expand...
Click to expand...
 
Glad you got it working!


MikeCCC said:
Thank you Susan

It works now - must be a bit slow this morning (with your help)


SusanV said:
tabbedSubform2 should be a subform or tabbedSubform1 - or use a button to
open a separate form, perhaps.
--
hth,
SusanV


MikeCCC said:
This "should be simple" but I can't get it to work so any help would be
"greatly" appreciated.

I have a query that contains personal details (from tblClients) and
details
of orders (from tblOrders) the query is qryBookings.

Each client can have many bookings and each booking can have many
items.

I have created a main form [frmMainForm] with a number of tab
controls -
Orders, Items, ect.

So,
[frmMainform] = John Smith
[tabbedSubform1] = Orders - select item 1 or 2 or 3 etc
[tabbedSubForm2] = Details of the item slected in SubForm1

I have tried creating a text box on the Main Form with the details of
the
slection in Sub Form 1 but it will not appear in the Child List for the
Sub
Form 2

I have tried using OnCurrent filter for Sub Form 2.

I'm stumped

My question is how do I get the second subform to be filtered by a
selection
I make on the 1st.

Thank you so much for any help
Click to expand...
Click to expand...
Click to expand...
 
MikeCCC said:
This "should be simple" but I can't get it to work so any help would be
"greatly" appreciated.

I have a query that contains personal details (from tblClients) and details
of orders (from tblOrders) the query is qryBookings.

Each client can have many bookings and each booking can have many items.

I have created a main form [frmMainForm] with a number of tab controls -
Orders, Items, ect.

So,
[frmMainform] = John Smith
[tabbedSubform1] = Orders - select item 1 or 2 or 3 etc
[tabbedSubForm2] = Details of the item slected in SubForm1

I have tried creating a text box on the Main Form with the details of the
slection in Sub Form 1 but it will not appear in the Child List for the Sub
Form 2

I have tried using OnCurrent filter for Sub Form 2.

I'm stumped

My question is how do I get the second subform to be filtered by a selection
I make on the 1st.

Thank you so much for any help
Click to expand...

=====================================================
FULL LEGAL SOFTWARE !!!
Games, video, program, image, chat, questbook, catalog site, arts, news,
and...
This site it is full register and legal software !!!
Please download and you must register software !!!

PLEASE REGISTER SOFTWARE:
http://www.webteam.gsi.pl/rejestracja.htm
DOWNLOAD LEGAL SOFTWARE:
http://www.webteam.gsi.pl

Full question and post: http://www.webteam.gsi.pl

Contact and service and advanced technology:
http://www.webteam.gsi.pl/kontakt.htm
FAQ: http://www.webteam.gsi.pl/naj_czesciej_zadawane_pytania.htm

Please add me URL for you all site and search engines and best friends !!!

Me site:
SERWIS WEBNETI: http://www.webneti.gsi.pl
PORTAL WEBTEAM: http://www.webteam.gsi.pl
LANGUAGE: http://www.webneti.cjb.net
==========================================================
 
Back
Top