Record Source for SubForm

  • Thread starter Thread starter David F
  • Start date Start date
D

David F

I have a subform that has a query using a left join as its record source.
The left join works fine when the form displays by itself. But when the
subform is displayed in the parent, the left join is converted to an inner
join.

For example. The subform returns a set of records listing investment and
amount. The subform includes all investments regardless of whether an
inestment has an amount associated with it. However, when embedded in the
parent form, the subform returns only those records that have a associated
amount.

The reason for this behavior is that the parent form is related to the
subform through the client ID. Only investments associated with a client ID
have an amount associated with them. So investments without amounts do not
show up in the subform when it is embedded in the parent form.

But can I get these records to show?

For any client record (parent form) I want the subform to show all possible
investments regardless whether the client has an amount associated the
investment.

Thanks for any ideas.
Dave
 
You are going to have to forego using "ClientID" in LinkMasterFields and
LinkChildFields, as I would guess you have done. I'm afraid I didn't get
enough detail of what you actually have and are doing to offer more specific
advice.

Larry Linson
Microsoft Access MVP
 
Back
Top