subforms - missing data

  • Thread starter Thread starter SNicholls
  • Start date Start date
S

SNicholls

In an Access 2000 database, I have a form with two
embedded subforms. When I enter data, it is correctly
recorded in the form and in the datasheets; but when I
close the form and reopen it, I cannot see the previous
data; it starts on a new, blank form. I want to be able
to see the previous entries to facilitate
corrections/additions to prior entries.

I tried changing the form properties to continuous, but
got an error message that I couldn't choose continuous
when a form contains subforms.
 
Almost sounds like the Data Entry property of this form is set to True.

1. Open the form in Design View (the main form).
2. Go to the form's Properties List.
3. On the Data or All tabs look for the option that says: "Data Entry"
4. Does it say No or Yes? If it says Yes that means ONLY new records can be added using this form.
If you create some records, for example, and then close the form the records will be saved. When you
re-open the form, however, you will be on a new record and will not be able to view past records.
5. Change that option to No, save and close the form.
6. Open the form and you *should* now see all the records from the table.
 
Back
Top