Subform shows blanks but Mainform does not

[krissy21]

Hello all,

I have a SubForm created from a query that shows an employee's training based on their EmployeeID. When I open the SubForm, it shows the training with dates applicable but also the training which does not have date (This is what I want). But when I open the MainForm, only the training with applicable dates is showing. Any one have an idea how I can get all the training to show on the MainForm?

 

[krissy21]

Uncle Gizmo,

Yes that is correct. When I open the SubForm as a stand-alone form, all the training shows. Those with dates and those without.

When I open the MainForm which carries the SubForm, only the training with dates shows.

I want all of the training to show, not just the ones with dates applicable.