Store Multiple Values from Form into Table

[Ian]

I have a survey form - with four values for each row (datasheetview).
CustomerID, UserID, QuestionID and ResponseValue. Employees will answer the
same question for 100 customers. ResponseValue is a combobox with values 1-5

The four values will be stored in a table called "Tbl_responses" but I want
the form to be populated from a table of customers, users and questions. The
values for the combobox will also come from a table but I want the reponding
value to be stored with the 3 other values

Can someone point me to a link on how to create this then store the value in
the responses table when the user closes the form? I assume I need some form
of an append query but I'm not sure how to design the logic.

 

[Arvin Meyer [MVP]]

The correct way to do this is with 4 rows of data. Storing multiple values,
particularly dissimilar data in a field is a gross violation of database
normalization rules. Access 2007 will let you do this, but it is still
highly unadvisable.

 

[Ian]

Hey Arvin -- no intention of storing all 4 sets of data in 1 field. I just
want to pass the 4 fields from 1 row on the form into a table where each row
will have the same 4 fields.

 

[Arvin Meyer [MVP]]

I'm not sure I understand. Simply binding the form to the table will
accomplish that. That's the default behavior. You have only a 100 customers
to worry about, but even if you had 10,000, the amount of data is still well
within the realm of bound form recordsources. Now if you have hundreds of
thousands of rows, you might want to consider using unbound forms and update
queries.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com