Linking subforms

[Guest]

Any ideas how to link two subfoms, not nest them, and not linking them to the
parent (master), link to each other. So that one subform can read the data on
the other subform. IE show me records on sub form 2, where field on subform 1
= X.

I basically want to link two subforms on two seperate tabs, so that whehn I
navigate through recors on one subform, the data on the second subform is
related to the first subform. All data is coming from the same table.

Another way to explain is:

I have two subforms based on the same table (representative).
The master is frmCustomer. The children are subfrmRepfirst and
subfrmRepsecond.

I want subfrmRepfirst and subfrmRepsecond linked somehow, so that when i
navigate thorugh a representative on subfrmRepfirst the details on
subfrmRepsecond match the rep that is shown on subfrmRepfirst. As stated all
the details are coming from the same table.

 

[Edward G]

Griffo,

You asked this question yesterday and three people left you responses
including myself. Was none of the information useful?

Ed

 

[Guest]

Nope. None of the information appeared to be useful.

The responses I perceived as being in relation to master and child
relationship of a 1:M table relationship. I have the one table (which is the
M side of a 1:M relationship), which I want to split over two tabs. When you
navigate through the records (of the M table) set one one tab, the
corresponding recordset is shown on the other tab.

For eample: If I had first name on one tab and last name on the other and
the content of the (M) table was:

Jack Smith
Jane Rogers

When I navigated from Jack to Jane on tab number 1, I want tab number two to
show Rogers when I click on it, at the moment it shows Smith still.

The responses yesterday did not assist as I preceived them as being linking
the master (1) to the many (M) of a realtionship, which is not the problem,
the subforms are already linked to the parent effectively, I just want them
to link to each other. If I have misunderstood the repsonses then I may need
clarification.

Thanks for your response again.

 

[Edward G]

Griffo,

I want you to try something for me. It shouldn't take more than 5 minutes,
probably less. I am working in Access 97 but I
don't think it matters what edition you have.
1. Open Access.
2. Select create a new database with Database wizard.
3. Select Order Entry database.
4.On the 2nd page of the wizard select "Yes, include sample data."
5. Keep hitting next till database is complete and opened.
6. Go to the database window and on the Forms tab click New.
7. Use the form wizard to create a datasheet form based on the Customer
table. Include the fields: Customer Id, CompanyName, City, and State. Call
this form CustomerSubform1 and save it.
8. Use the form wizard to create a second datasheet form based on the
Customer table. Include the fields: Customer Id, Company Name,
ContactFirstName, ContactLastName, and Phone. Call this CustomerSubform2 and
save it.
9. Create another new form in Design view again based on the Customer table.
10. Resize this form so you can work comfortably and add 3 tabs with the tab
control tool. You will have Page1, 2, and 3.
11. On page 2, use the subform tool to add CustomerSubform1. Accept the SQL
default, keep hitting next till complete.
12. On page 3, use the subform tool to add CustomerSubform2. Accept the SQL
default, keep hitting next till complete.
13. On page 1, use the Listbox tool to create a list box. In the wizard
select the 3rd choice "Find a record on my form based on a value I selected
in my list box. Accept all the defaults and finish.
14. Open the form and verify that it is working as you describe.

Edward G the unholy - user of Lookup fields, Send Keys, and Unsplit
Databases.

 

[Guest]

Tried it. Thanks for you efforts.

Griffo,

I want you to try something for me. It shouldn't take more than 5 minutes,
probably less. I am working in Access 97 but I
don't think it matters what edition you have.
1. Open Access.
2. Select create a new database with Database wizard.
3. Select Order Entry database.
4.On the 2nd page of the wizard select "Yes, include sample data."
5. Keep hitting next till database is complete and opened.
6. Go to the database window and on the Forms tab click New.
7. Use the form wizard to create a datasheet form based on the Customer
table. Include the fields: Customer Id, CompanyName, City, and State. Call
this form CustomerSubform1 and save it.
8. Use the form wizard to create a second datasheet form based on the
Customer table. Include the fields: Customer Id, Company Name,
ContactFirstName, ContactLastName, and Phone. Call this CustomerSubform2 and
save it.
9. Create another new form in Design view again based on the Customer table.
10. Resize this form so you can work comfortably and add 3 tabs with the tab
control tool. You will have Page1, 2, and 3.
11. On page 2, use the subform tool to add CustomerSubform1. Accept the SQL
default, keep hitting next till complete.
12. On page 3, use the subform tool to add CustomerSubform2. Accept the SQL
default, keep hitting next till complete.
13. On page 1, use the Listbox tool to create a list box. In the wizard
select the 3rd choice "Find a record on my form based on a value I selected
in my list box. Accept all the defaults and finish.
14. Open the form and verify that it is working as you describe.

Edward G the unholy - user of Lookup fields, Send Keys, and Unsplit
Databases.