Saving Form Entry to a Table

[Junkie88]

I have a form whose record source is a query. But I want to save this form entry to a table. How do I do that?

 

[dhookom]

Isn't your query based on "a table" or tables? You can change the record source of a form to the table.

Duane
Hook'D on Access
MS Access MVP

 

[Junkie88]

yes, my query is based on a table, q, but not all the fields on the form belong to that table, q. Only one of them does. I want to save all these fields to another table, p.

How do I do that when the record source of my form is not that table i.e. p?

 

[dhookom]

You might be able to use a subform on your main form. Base your subform on any other record source.

Are you query and table related in any way?

Duane
Hook'D on Access
MS Access MVP

 

[PHV]

Have a look here:

http://support.microsoft.com/kb/148581

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Junkie88]

The query retrieves some questions from the Question table. And I want them to be displayed one by one so that I can record answers to those questions. The table will store question number and answers to questions and some other identifying fields.

 

[MajP]

You are probably going to have to explain your tables and relationships. This may help to that faq700-6905.

If this is like a survey db then the normal way to do that is generally something like this.

tblQuestions
questionID (pk)
question fields

tblPersons
personID (pk)
fields about the person taking the survey

tblAnswers
answerID (PK)
This is for non open-ended questions ("good", "bad", "True, False, etc."

juncTblPersonQuestionAnswer
personID_fk
questionID_fk
answerID_fk


Now the problem is that every user needs to be presented all questions. So normally what I do prior to opening the survery form is an Insert query that ensures that in the junction table there is every question ID for each person.

 

[MajP]

The last line should read: "there is a questionID for every question, for every person