drunkcrusher78
Registered User.
- Local time
- Today, 12:37
- Joined
- Mar 16, 2004
- Messages
- 13
Hello all,
First off, I have no expierence in programming, and very limited knowledge of MS Access. I have sucessfully set up a database that I use at work to keep track of my arrests. I think my question (problem) is a simple one, but I cannot figure it out. Here goes..
I have a main form that I enter all of my information. There are over 200 fields to be filled in, so I want to break this form up into several forms that will all share the same database. Basically, I want to add control buttons to access 3 seperate forms, that when filled will add to the same record that the main form is accessing (different information of course).
I have set up my form, where whenever I click on the control buttons, the other forms come up. But where I run into a problem is that I cannot figure out how to make these additional forms share the same table as the main form. It tells me that the table is already being accessed by the main form.
Can this even be done? If so, could someone be so kind as to give me the information in dummy-proof language. I hope I am making sense.
Thanks a million,
Oren Haydel
P.S. One more clarification...this is what I want to do, in simple terms:
Fill out all the fields on the main form, click a command button, it pulls up and additional form, I fill out these fields, and it adds the info to the main table ( the same one that the main form is accessing). I also need these extra forms to access the database coincide with the same record as the main form.
First off, I have no expierence in programming, and very limited knowledge of MS Access. I have sucessfully set up a database that I use at work to keep track of my arrests. I think my question (problem) is a simple one, but I cannot figure it out. Here goes..
I have a main form that I enter all of my information. There are over 200 fields to be filled in, so I want to break this form up into several forms that will all share the same database. Basically, I want to add control buttons to access 3 seperate forms, that when filled will add to the same record that the main form is accessing (different information of course).
I have set up my form, where whenever I click on the control buttons, the other forms come up. But where I run into a problem is that I cannot figure out how to make these additional forms share the same table as the main form. It tells me that the table is already being accessed by the main form.
Can this even be done? If so, could someone be so kind as to give me the information in dummy-proof language. I hope I am making sense.
Thanks a million,
Oren Haydel
P.S. One more clarification...this is what I want to do, in simple terms:
Fill out all the fields on the main form, click a command button, it pulls up and additional form, I fill out these fields, and it adds the info to the main table ( the same one that the main form is accessing). I also need these extra forms to access the database coincide with the same record as the main form.
