Data overwritten and not saved ?

  • Thread starter Thread starter Gerard Boxter
  • Start date Start date
G

Gerard Boxter

Hello all,

Wow, I just found this site, and it seems you might be
able to help me with my problem !

I programmed a cycle of forms for the data entry, where
data need to be filled in for different periods.
Now I am testdriving the database, and I encounter the
following problem:
When for example I have a form X filled in for
patientnumber 1 period 1, and (after filling a number of
subsequent forms) go to the form X for patient 1 period 2
(so next period), I have visible the data for period 1.
When I then fill the data for period 2, the data for
period 1 are overwritten. Ofcourse, I need them both to be
stored in the table.

So: how can I get the form X empty in the second (third,
fourth,...) round, and how do I get the data to be stored ?
Can anyone help ? Thanking you in advance !
 
It sounds like you have the form's record source set as a
query. It IS possible to do that but it's better to set
the data source as an inividual table and utilize subforms
for related data. I think once you do that you won't have
that problem anymore.
 
Hi Bob,

Thanks, but no, that is not the problem. I have used
individual tables for the different forms, except the
forms that the data entrist encounters multiple times. The
forms record source is not set as a query.
I just want to be able to store multiple lines (i.e.
periods) for the same patient in a table, without
overwriting them.
 
Back
Top