Help making a form...

[jetstrike]

This is probably a stupid question but could you please tell me how i can set up a form in access to look similar to the one in the attached picture?

 

[FoFa]

You would either have to use frames and radio buttons (but there would be frame lines since you can't turn them off), or use radio buttons/check boxes, but control the line they are on with VBA code to act like a frame (only allow one checked).

 

[jetstrike]

That would be great but i need to store data values for each thing depending on wether they click 1 - 6 or and have that value used in the 1 table and i need it so they can only choose 1

 

[Mile-O]

Do a search on questionnaires and surveys. Lots of posts on the topic.

Your current method makes me think you have not normalised your database.

 

[FoFa]

A frame allows you to assign a value to each radio button, so they would be 1-6 and you could store that value in a single field for each question.
Example:
AnswerTable;
AID autonumber
QID Long (Ties to question table)
RespondentID (ties to who took the questionare)
Answer (1-6 depending on what is selected)

But you need to use frames (and the associate frame box with it) for the easiest solution. Think of the frame a group of radio controls, only one is allowable for selection and each has a unique value within the group).
The attached file is kind of an example.