Connecting 2 Forms

[Toya2176]

I have two forms that are linked through FileID. I could have Form A and then Subform b, but I need all the space I can get so I wanted one form that allowed me to type all the file information, click a button and connect it to a Form B where you list everything in that file. I wanted a form to itself to do that because like I said I wanted all the space I could get. Well, I created the Form A and the button to go to Form B, but the information isn't saved. Form B is blank even after I typed in the information. When I go back nothings there. How can I correct this problem. I want to click this button and linked by the File Number (FileID) everything in that file will pop up. Right now the FileID is showing blank on the Form B, it isn't being populated by the Form A. Please any help would be appreciated.

Toya

 

[Zebbeddee]

Once you have typed something into FormA what does your button do to put it into FormB or does it just switch forms. If so you may need to put the data into your tables first and then switch over to FormB telling it to use the FileID from FormA and recall the data from these.
If typing something in a form automatically updated your table information then as far as I can tell your situation would work but access doesn't do that.


Booiinnggg ... Zebbeddee ... Booiinnggg

 

[Toya2176]

You know if I go through the actually table section and manually input the File ID into that second table for Form B, and then on the forms click the button the file information will come up it actually finds it then. I thought that maybe I could have the two seperate forms that acted like a Parent and Child (Form & subform). But if that is not possible that's find with me. I had no problem doing it that way, but my problem was when new files were added and I'm not going to be the only user, explaining that process to the other people.

I appreciate your help Zebbeddee. You have a good day.