On Sat, 17 Mar 2007 05:09:08 -0700, Bill NC <Bill
I have a subform that will not show all records that are associated with the
main form.
At this time I have to go back to a "backup" to reinstall the database and
then re-enter the lost records.
I have 900 records in the mainform and 1600 records in the subform database.
The data is, of course, not stored in the Form nor in the Query. The data is
in the tables.
Have you checked to see if the records in the subform's table (*not* Database,
please - a Database in Access jargon is the .mdb/.mde file container for all
the tables, forms, and other objects) are in fact getting deleted? It's quite
possible that you have an error in the Query upon which the subform is based
so that it's just not *showing* those records; or an error in the Master/Child
Link Field or in the values of those fields in the table, so that the records
are simply not being included in the form's recordsource.
Perhaps you could check the Recordsource property of the mainform and subform,
and make sure there aren't any criteria that would exclude some records; and
check the master/child link fields. Post back with more details if you want
help.
John W. Vinson [MVP]