subform troubleshooting

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

Guest

Am not able to see subform in main form!Although i can see sub form
individually but not in main form. Its on many side of 1 to many
relationship/ When i see main form, i only see blank area and there's no sub
form. Please help
 
A subform typically shows only those records that match the record in the
main form.

If you expect records in the subform and they are not shown, Access is
probably performing this "matching" differently than you suspect.

Open the main form in design view.
Right-click the edge of the subform control, and choose Properties.
On the Data tab of the Properties box, clear these properties:
Link Master Fields
Link Child Fields

The subform should now show all the records from its table.
 
Back
Top