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

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...

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????

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

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.