Inserting form values into a table

[dufnobles via AccessMonster.com]

We have a form with values taken from an sql query that comes from two
different tables. We would like to enter the information into a third table.
Can some one direct me to code that will do the following:

1. Provide the Insert sql that shows us how to add the form values to the
table
2. Show us how to loop while inserting the information into the table (there
could be several lines on the form, each must be inserted one at a time).

I have worked with Access before and have never had a problem inserting
information. However, I cannot quite figure out how to insert informtion
through an Access form. By the way, we are using Access 2000.

Any help will be greatly appreciated.

 

[dufnobles via AccessMonster.com]

How does the form insert data when it comes from several different tables?

 

[Jeff Boyce]

I may be missing something...

It sounds like you want to take data you already have and duplicate it in
another table. Why?

If you can write a query that retrieves the data from the (two) table(s),
why not use the query as your source, rather than adding another table?

More information, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[dufnobles via AccessMonster.com]

Thanks Jeff.

I need to clarify. My form is a survey response form. If I have a survey
question that needs four responses, then I display four rows, one for each
answer. This works fine.

My problem is that once the user fills in the four rows, I do not know the
best procedure to store all four rows of text into another table that was
created to hold the responses. I have a Save button but I am unsure of the
logic needed to get all four responses added to the table.

Thanks.

I may be missing something...

It sounds like you want to take data you already have and duplicate it in
another table. Why?

If you can write a query that retrieves the data from the (two) table(s),
why not use the query as your source, rather than adding another table?

More information, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

We have a form with values taken from an sql query that comes from two
different tables. We would like to enter the information into a third

[quoted text clipped - 12 lines]

Any help will be greatly appreciated.

 

[Jeff Boyce]

I'm still having trouble visualizing the data you have and what you are
trying to do with it.

You've described the form ("four rows"...), but why, for example, are there
four, rather than 3 or 5 (or just 1)?

You've described storing the rows/responses into a table to hold
responses... but I don't have a clear picture of your data structure.

It all starts with the data. Please post a description of the tables you
currently have set up.

Regards

Jeff Boyce
Microsoft Office/Access MVP

Thanks Jeff.

I need to clarify. My form is a survey response form. If I have a survey
question that needs four responses, then I display four rows, one for each
answer. This works fine.

My problem is that once the user fills in the four rows, I do not know the
best procedure to store all four rows of text into another table that was
created to hold the responses. I have a Save button but I am unsure of
the
logic needed to get all four responses added to the table.

Thanks.

I may be missing something...

It sounds like you want to take data you already have and duplicate it in
another table. Why?

If you can write a query that retrieves the data from the (two) table(s),
why not use the query as your source, rather than adding another table?

More information, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

We have a form with values taken from an sql query that comes from two
different tables. We would like to enter the information into a third

[quoted text clipped - 12 lines]

Any help will be greatly appreciated.