I'm sorry to have to use xBase terms, but it's the only way I know to
get my message across.

I have a single form acting on a single table in a single database.
The application is to enter the results from a survey.   The survey
has 36 questions with a Low, Medium, High response possible to each
question.  I have created a form with 36 frames and three check boxes
in each frame.  What I would like to do is do an "append blank" then
fill in the check boxes, then write the a new record.  After the
frames on the screen I have a command button with the programming
data1.recordset.addnew, this works to a certain degree.   The problem
is that when I run the program a 2nd, 3rd, etc. time, the form comes
up with a few of the check boxes already checked off.   When I try to
enter test data it appears that the last record of the previous run is
being overwritten by the first data entry screen from the current run.

I know it must be something simple, please help, the pressure is on !!

thanx .......

========================================================================
David Laneville, Manager of I/S, City of Timmins.
Snail Mail:     220 Algonquin Blvd E., Timmins, Ontario.  P4N 1B3
========================================================================
If it wasn't for the last minute, not a damned thing would get done !!

Hi David. or Skinny.

I assume you have bound your Check Boxes to your database table. That is
what is sounds like.

In general terms, you want to do the following:

Data1.Recordset.AddNew

Data1.Recordset("Field1") = Check1.Value
Data1.Recordset("Field2") = Check2.Value
Data1.Recordset("Field3") = Check3.Value
Data1.Recordset("Field4") = Check4.Value
etc.

Data1.Recordset.Update

You need to do the AddNew before checking any of the boxes, and again
before entering any new data.

Let me know if I can be of any more help.

=========================================
"When the going gets tough, the weird turn pro."
         -- R. Duke

=========================================