I found a better way!! this is what I did on the form initialize;
Do While counter < records
If Data2.Recordset.youranswer <> "" Then
Data2.Recordset.Edit
Data2.Recordset.youranswer = ""
Data2.Recordset.Update
Data2.Recordset.MoveNext
Else
Data2.Recordset.MoveNext
End If
counter = counter + 1
Loop
It works just the way I wanted. Whew!!
Thanks you for your suggestion though.
>Make a Table called "ANSWERS" and name the field "YourAnswers"
>remove it form the second Table. Then create a sql statement in the
>Form_Load to delete all the records in the ANSWERS Table, before
>you load the rest of the database. This way the answers will all ways
>be blank when the database is loaded. Also make sure that you have
>Allow Zero Length in Access set to yes, that way if the answer is left
>empty you will not get a error.
>HTH,
>etta
>>I am creating a Visual Basic app which will be used to test proficiency
>>levels for employees. I am using MS Access as the database engine. I
have
>>two tables;
>>1.) Employee Data: (Last Name),( First Name), (Employee Number),
(Date),
>>(Test Score)
>>2.) Proficiency Test: (Questions), (Correct Answer), (Your Answer)
>>How can I clear the records in the field (Your Answer) automataically when
>>the program is initiated?
>>I have been struggling with the program and I cannot seem to resolve the
>>problem. data1.recordset.edit seems to be the appropriate tool, but I
>don't
>>understand how to use it.
>>Any help would be greatly appreciated.
by