Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data visible then its gone

Status
Not open for further replies.

h20vrrq

MIS
May 28, 2008
21
GB
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.
 
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'.



 
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.
 
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
 
Yes, everyone who needs it has a copy of the database.

The Score is being saved in the table.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top