Forms into Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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???
Click to expand...

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
 
Back
Top