Data visible then its gone

[h20vrrq]

I've been asked to create a database that needs only to store the answer to 6 questions. Each answer will only be between 1 and 9.
Each question needs to appear separately so I have created 6 forms, one for each question.

The table used to store the answers (Scores) is very simple, and just has question number and answer.

On each form I have the question as a simple label, and below this I have text box that allows the user to record the answer. This seems to work ok as the answer is stored in the table (I have a hidden field with question number set as default that also writes back to the table)

On each form there are two buttons, continue and back. If I go back to the form I have just entered the answer in, the answer is not shown. As its possible the user may want to change there answer, what do I need to do to show the previously recorded answers on the forms?

Hope this makes sense.

As seems usual this is an urgent request so I really would appreciate any help.

 

[dhookom]

Can you share your table structures and form record sources?

Duane
Hook'D on Access
MS Access MVP

 

[h20vrrq]

The table structure is as follows:

Table name is 'Scores'
Field 1 is 'Question' with data type of Number
Field 2 is 'Score' with data type of Number

The forms all have a Record Source of 'Scores'.

 

[dhookom]

How do you keep track of "the user"?

Duane
Hook'D on Access
MS Access MVP

 

[h20vrrq]

The database is only accessed by a single user at a time so I didnt think I need to keep track of them. There will only ever be one set of answers stored at any one time.

 

[dhookom]

So, everyone has their own copy of the database? Do you have 6 records in the table?

Have you looked at the datasheet view of the table to see if the Score is being saved?

Duane
Hook'D on Access
MS Access MVP

 

[h20vrrq]

Yes, everyone who needs it has a copy of the database.

The Score is being saved in the table.

 

[dhookom]

If the form's Data Entry property is set to "Yes" try change it to "No".

I'm confused regarding your entire solution of separate databases etc. I guess you know your requirements better than I do but it doesn't seem correct to me.

Duane
Hook'D on Access
MS Access MVP