Subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Your complaint implies that you wanted all of the records for the main
form to show. I'll rashly infer that's the case.

Make sure that the query for the main form returns ALL of the records
from the main table per the query/relationship properties.

HTH
--
-Larry-
--

Bill NC said:
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
Click to expand...
database.
 
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.
Click to expand...

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]
 
You were right on, I found the the subform Query had an error so I uesd the
Table for ith data source. tks
bill
 
Back
Top