Bound combobox only working on certain records

[Joseph Greenberg]

I have a bound combobox on a subform (cboSeqNo, bound to cboSeqNo in
qYDetail which is the record source for the subform) for which the rowsource
is:

SELECT DISTINCT qryGetFirstNames.SeqNo, qryGetFirstNames.Fname,
qYtDetail.FamNo FROM qYDetail INNER JOIN qryGetFirstNames ON qYDetail.FamNo
= qryGetFirstNames.FamNo WHERE
(((qYDetail.FamNo)=[Forms]![fMemberInfo]![FamNo])) ORDER BY
qryGetFirstNames.SeqNo;

The problem I am having is that when I'm on a record which has no associated
records in qYDetail, it does not populate the combobox with the child
records (or any records) for the current records. If there IS data for
qYDetail, I do get the proper elements in cboSeqNo. Another thuing that
seems relevant is that if I create a new record by typing in a text box on
the subform, if I press F9 then cboSeqNo does populate. How can I get the
cbo to populate without having to pretend to create a record on the subform?
And how can I eliminate the need for an F9 if I do actually want to start a
new record?

 

[Jeanette Cunningham]

You probably need a left or right join in the query in place of the inner
join.
I'm not sure if this one needs a left or right join.
If you make the query in the query design grid, you can choose to see all
the records from the main table and only the matching records ( if any) from
qYDetail.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia