Populate a table

[reysy28]

With the above layout of my table and form my question is how can I populate the EnglishAppAnswer table, the idea is every picture has 4 buttons, the applicant choose a button to click then the answer will be added to the EnglishAppAnswer table with also the AppID, TestDate fields coming from AppDataFile and QuestionID from EnglishSkillsPics table. The EnglishSkillsPics has several questionaires so every time the Applicant choose an answer it will go to the next question from the EnglishSkillsPics table until all questions are finished. And is it possible to put a timer on this? Please help..... thanks a lot.....

[June7]

One approach is to pre-create a set of records in the EnglishAppAnswer table for the applicant. Open form filtered to that set of records and code will save answer directly into record and advance to the next record when any button is clicked. This form RecordSource would be a query that joined EnglishAppAnswer to EnglishSkillsPics so the associated image and choices could be displayed.

Another approach would use a form bound to EnglishSkillsPics table and use code to run INSERT action SQL to save record to EnglishAppAnswer table when button is clicked and advance to next question.

I expect a timer is possible. Form has Timer event. Coding a timer is rather tricky.

[reysy28]

Thanks June7, i'll try the second approach....

[reysy28]

attached is my database... thanks sir....

[June7]

Suggest you make the form command buttons into toggle buttons or radio buttons in an OptionGroup control named optAns.

You will need the user's AppID. How does Access know who is using?

The APPEND query is not using values from the form and is adding data to the wrong table. I don't use macros - only VBA:

CurrentDb.Execute "INSERT INTO EnglishAppAnswers(TestDate, AppID, QuestionID, AppAnswer) VALUES(Date()" & Me.AppID & ", " & Me.QuestionID & ", " & Me.optAns & ")"

[reysy28]

Suggest you make the form command buttons into toggle buttons or radio buttons in an OptionGroup control named optAns.

You will need the user's AppID. How does Access know who is using?

The APPEND query is not using values from the form and is adding data to the wrong table. I don't use macros - only VBA:

CurrentDb.Execute "INSERT INTO EnglishAppAnswers(TestDate, AppID, QuestionID, AppAnswer) VALUES(Date()" & Me.AppID & ", " & Me.QuestionID & ", " & Me.optAns & ")"

Sorry am a newbie here, i dont even know VBA and where to put that.....

[June7]

That would be code behind the suggested option group control.

Or rebuild the query object correctly and stick with macro.