Linking two or more forms

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

Guest

I want to have 4 different forms displayed at one time on my screen. When I
change the value on my main form frmCompanyInfo I would like the other forms
to display the proper data based on the common field [AccountID]

The other forms will display continious data. Is it best to set the other
forms up based on the value on the main form and then requery the offset
forms on update of the main form or is there a way to link these forms
without them being subforms.

Thanks in advance for any help.
 
Why don't ypu want them to be subforms? If they share a common field,
AccountID, they are all related and the easiest thing to do is to use
subforms.
 
Main Form has Company Information
Form 2 has primary phone and fax informaton about that company
Form 3 has Contacts who work for that Company
Form 4 has phone information about the specific contact that has the focus.

I don't know if it can be done but I would like to right click on the form
that has the focus and bring up a data entry form specific to that form

Ie: Clicking on one of the contacts on form 3 will display all the phone
numbers for that contact on form 4. I want to be able to right click on form
4 and be able to add additional phone numbers for that contact such as pager
or cell so that when I click on that contact the next time all associated
phone numbers for that contact will display in form 4.

Right clicking on form 3 would allow me to add new contacts that work for
the company being displayed in form 1.

Maybe this is ass backwards but thats just what I was envisioning and trying
to accomplish.

Any suggestions or direction is greatly appreciated.



PC Datasheet said:
Why don't ypu want them to be subforms? If they share a common field,
AccountID, they are all related and the easiest thing to do is to use
subforms.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


cvegas said:
I want to have 4 different forms displayed at one time on my screen. When I
change the value on my main form frmCompanyInfo I would like the other forms
to display the proper data based on the common field [AccountID]

The other forms will display continious data. Is it best to set the other
forms up based on the value on the main form and then requery the offset
forms on update of the main form or is there a way to link these forms
without them being subforms.

Thanks in advance for any help.
Click to expand...
Click to expand...
 
Add a tab control with three pages to your main form. Make page#1 your phone
and fax informaton page. Create a subform control on page#1. Select the
subform control and set its source object property to Form2. Be sure the
LinkMaster and LinkChild properties of the subform control are AccountID.
Add a button on Form2 that opens a form in acDialog mode to enter new data
in the table Form2 is bound to. This form should have an OK button with code
that makes the form not visible. The code on the button on Form2 should also
have code that requeries Form2. Do the same for pages 2 and 3 and Forms 3
and 4.

Steve
PC Datasheet

cvegas said:
Main Form has Company Information
Form 2 has primary phone and fax informaton about that company
Form 3 has Contacts who work for that Company
Form 4 has phone information about the specific contact that has the focus.

I don't know if it can be done but I would like to right click on the form
that has the focus and bring up a data entry form specific to that form

Ie: Clicking on one of the contacts on form 3 will display all the phone
numbers for that contact on form 4. I want to be able to right click on form
4 and be able to add additional phone numbers for that contact such as pager
or cell so that when I click on that contact the next time all associated
phone numbers for that contact will display in form 4.

Right clicking on form 3 would allow me to add new contacts that work for
the company being displayed in form 1.

Maybe this is ass backwards but thats just what I was envisioning and trying
to accomplish.

Any suggestions or direction is greatly appreciated.



PC Datasheet said:
Why don't ypu want them to be subforms? If they share a common field,
AccountID, they are all related and the easiest thing to do is to use
subforms.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


cvegas said:
I want to have 4 different forms displayed at one time on my screen.
Click to expand...
When
I
change the value on my main form frmCompanyInfo I would like the other forms
to display the proper data based on the common field [AccountID]

The other forms will display continious data. Is it best to set the other
forms up based on the value on the main form and then requery the offset
forms on update of the main form or is there a way to link these forms
without them being subforms.

Thanks in advance for any help.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top