 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / December 2005Forms into Table
I need to enter information into a form and dump it into a table (no problem). How do I go about entering information into a form for multiple people to return multiple rows with the table. Do I need a different form for each person??? Thanks If you are saying you want to return multiple rows for each person, then you need a form/subform setup. The form should have the information on the person and the subform should have the multiple rows for the person. If you need more specific information, please post back with more detail on what you are trying to accomplish. > I need to enter information into a form and dump it into a table (no > problem). How do I go about entering information into a form for multiple > people to return multiple rows with the table. Do I need a different form for > each person??? > > Thanks Not quite. I have a form with 8 fields in, linked to a table. When I input data into the form, this then generates data on the first row of the table. Fine, no problem. What I now need to do, is work out how to generate a second set of details in row 2 of the table. Is there a way I can change the form so that it can be added into this once, or do I have to have a separate form for each rown in the table? Happy to explain more! Thanks > If you are saying you want to return multiple rows for each person, then you > need a form/subform setup. The form should have the information on the [quoted text clipped - 9 lines] > > > > Thanks >I need to enter information into a form and dump it into a table (no >problem). How do I go about entering information into a form for multiple >people to return multiple rows with the table. Do I need a different form for >each person??? Of course not. Access Forms (unless you've customized them) do this automatically - if you enter data into several fields, and then tab out of the last field in the tab order, you should be in a "new record", blank and ready for more input. Or, you can press the *> icon in the navigation buttons at the bottom of the form. It is *possible* to set up a form which traps the user on a single record, but you have to do so deliberately. I'm guessing that you have not done so. Note also that you don't need ANY code or macros to "dump" data into a table - a default bound form does so all by itself with no intervention needed on your part. Maybe you're trying too hard! John W. Vinson[MVP] Spot on, thankyou. Once entering data for one person, I was not tabbing right the way through the form and hence not able to enter data into the second/nth row of the table > >I need to enter information into a form and dump it into a table (no > >problem). How do I go about entering information into a form for multiple [quoted text clipped - 16 lines] > > John W. Vinson[MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.