Datasheet - ascending order

[c8tz]

Hi ,

I have a form that is used to enter the results/responses obtained
from a questionnaire. The form i've created is bound to a table -
which has QuestionID and then the response is entered in.
I would like it so that the form (datasheet view) shows the questionID
automatically. ie. at the moment i have to type in question 1 then the
response.

I would like so that 1 comes up on its own and all i type in is the
response.

Thanks so much....

 

[Tom van Stiphout]

On Tue, 7 Oct 2008 21:14:40 -0700 (PDT), c8tz <[email protected]>
wrote:

Perhaps it's an option to make QuestionID an AutoNumber?

-Tom.
Microsoft Access MVP

 

[c8tz]

Perhaps it's an option to make QuestionID an AutoNumber?

-Tom.
Microsoft Access MVP

Hi Tom,

Thanks for your reply - If I do that, will the next record, then start
with 1 again or will it continue? ie. if for respondent 1 - last
question is 20 - if i do respondent 2 - will it begin with 1 or will
it start off with 21?

anyways i'll try it and see - and wait for more assistance -

greatly appreciated-

thanks.

 

[c8tz]

Hi Tom,

Thanks for your reply - If I do that, will the next record, then start
with 1 again or will it continue? ie. if for respondent 1 - last
question is 20 - if i do respondent 2 - will it begin with 1 or will
it start off with 21?

anyways i'll try it and see - and wait for more assistance -

greatly appreciated-

thanks.

hi tom,

OK - I have three tables:

tblQuestions : This I've put QuestionID - AutoNumber and Question -
The question.
tblRespondents: RespondentID (Autonumber) , Name, Company etc
tblResponse: RespondentID, QuestionID, Response1, Response2 (R1, R2 -
rating - combo of 0 -5)

The form I created:-

Main Form: made from Respondent Table
subform: Response Table which has subform : tblQuestions.

The subform shows in a datasheet and for each respondent I enter the
question number, R1, R2.

the subform (from response table - contains questionID - but this is
of type : Number which is linked to the tblQuestions : QuestionID
(autonumber)

would this explain why I still won't get a auto number generated after
entry of last question?

Please help.

Thanks.