Linking forms to forms and so on..

[Babi_C]

First of all! Let me just say "Thank you god!" I have been looking all over for an MS Access forum for months now and I finally found one. Here is my problem:

Ok, let's see if I can explain this...Say I have one main form, it has
basically all the general information for each record in the database, but I
want some of this information to automatically come up on other forms--like
a Bank Name, or a piece of Equipment, I want it to appear on more than one
form, only entering it once. Do you have any idea how to do this??? Please feel free to ask questions to get a better idea of what I'm talking about. I look forward to your help!!!!

Chloe

 

[Jack Cowley]

Are you wanting to enter data into muliple forms with the data going to the same table or are you trying to display data from a single table on multiple forms?

It sounds like you want to display basic information on a form and then if the user wants to see Bank information related to the displayed record then a click of the Bank button would display the Bank form with the proper data displayed.

Give us a bit more detail and someone will have an answer for you...

 

[Babi_C]

You are right on. I basically want multiple forms to pull information off a single table -- and all fall into one record..So if I was in a record (a form called "Main Form") for "Customer A", and I wanted to see their bank information, I want to be able to click on the "Bank Form" and be able to see their bank information. Is that any more clear????

 

[charityg]

Just base your subforms on the same table as your main form, and only put the fields that you want to display on the subform

 

[Babi_C]

Do they have to be subforms? Because I don't know how to make subforms. I have many different forms--and am using the same tables for all these forms--via queries etc. I can't get the forms to match up with each other though.