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 !!
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 !!!!