Why does my subform not show records that are in the tables?

[Daniel B]

I have a subform that displays records of information. When a new record is created and saved, the record will appear in the tables, but not in the subform.

It seems that when I fill in information for all fields in a record and save it, it will then appear in the subform, but if some fields are left empty (which is necessary is some cases) it will not appear in the subform.

Any help is much appreciated!

Dan B.

[jimatqsi]

Subforms are linked to main forms through the master/child relationships in the properties of the subform. Review what you have there. It seems likely there is something in that linkage that is causing your problem.

You mention only one table. Is the subform showing information from the same table as the main form? If the subform is showing records from a different table, please verify that the table is being populated in all instances. Maybe the problem is that the table does not get populated if you don't fill in all fields.

Jim

[munkee]

If you are mentioning some fields being left empty results in no record showing then if your subform is based on a query you need to check the relationships of your joins to ensure they will show if certain fields are not present.