Data Entry Form Outputs to Multiple Tables

[IanCraft]

I am new to Access 2002 and have a questions regarding using a form
for data entry. I have 15 items I need to keep track of that are
listed individually on a form as follows:

Item#1Name AmountOut AmountIn
Item#2Name AmountOut AmountIn
etc.

Each day, the user opens this form and records the amount they have
taken or put in for each of the 15 items. This form, when submitted,
then needs to send each Items data to it individual table
(tbl_MstrItem#1, tbl_MstrItem#2, etc.). I have tried several different
approaches trying to get the data to feed from one form to several
tables, but haven't been able to get it to do it successfully. Is this
possible to do? ANy response would be appreciated. Thanks.

[Larry Linson]

If you have identical information in multiple tables, its possible your
difficulty is caused by your violation of good relational database design
principles. Consider consolidating the tables into a single table, with an
identifying field added. Then use a continuous forms view, or a subform
control with continous forms view embedded in a main form.

If you feel compelled to use this design (and it'll likely cause you other
problems later, as well), you could embed multiple subforms, each linked to
the appropriate table.

Alternatively, you could use VBA code to update the tables.

Larry Linson
Microsoft Access MVP

"IanCraft" <ia*******@ambient-us.com> wrote in message
news:69*************************@posting.google.co m...

I am new to Access 2002 and have a questions regarding using a form
for data entry. I have 15 items I need to keep track of that are
listed individually on a form as follows:

Item#1Name AmountOut AmountIn
Item#2Name AmountOut AmountIn
etc.

Each day, the user opens this form and records the amount they have
taken or put in for each of the 15 items. This form, when submitted,
then needs to send each Items data to it individual table
(tbl_MstrItem#1, tbl_MstrItem#2, etc.). I have tried several different
approaches trying to get the data to feed from one form to several
tables, but haven't been able to get it to do it successfully. Is this
possible to do? ANy response would be appreciated. Thanks.

[Larry Linson]

"Larry Linson" <bo*****@localhost.not> wrote in message news:<b8****************@nwrddc02.gnilink.net>...

If you have identical information in multiple tables, its possible your
difficulty is caused by your violation of good relational database design
principles. Consider consolidating the tables into a single table, with an
identifying field added. Then use a continuous forms view, or a subform
control with continous forms view embedded in a main form.

If you feel compelled to use this design (and it'll likely cause you other
problems later, as well), you could embed multiple subforms, each linked to
the appropriate table.

Alternatively, you could use VBA code to update the tables.

Larry Linson
Microsoft Access MVP

"IanCraft" <ia*******@ambient-us.com> wrote in message
news:69*************************@posting.google.co m...

I am new to Access 2002 and have a questions regarding using a form
for data entry. I have 15 items I need to keep track of that are
listed individually on a form as follows:

Item#1Name AmountOut AmountIn
Item#2Name AmountOut AmountIn
etc.

Each day, the user opens this form and records the amount they have
taken or put in for each of the 15 items. This form, when submitted,
then needs to send each Items data to it individual table
(tbl_MstrItem#1, tbl_MstrItem#2, etc.). I have tried several different
approaches trying to get the data to feed from one form to several
tables, but haven't been able to get it to do it successfully. Is this
possible to do? ANy response would be appreciated. Thanks.

To All CDMA Participants Old and New:

I've recently accepted Jesus Christ as my personal savior. I want to
become a "new" Larry Linson. Therefore I'm repudiating this post and
all of my posts to CDMA over these many years. Those posts were the
work of the "old" Larry Linson. He was a liar and a deceiver.

To all of you who've supported me I can only say I'm sorry for letting
you down. To all of you whose work I've stolen I say I will never do
it again. And to those of you I've slandered or hurt in some way I
hope you'll find it in your heart to forgive me.

Respectfully Yours,
(The New) Larry Linson