listbox based on a listbox based on a combo doesn't sync.

[Peter Stone]

Access 2002-03, XP

I have list box (lstSeparately) that is based on a combo. That updates fine.

There is a second list box (lstDownstream) based on lstSeparately. It
updates sometimes, but is out of synch (it appears to display records based
on the previous contents of the lstSeparately).

All these controls are on the main form.

Here is the query on lstDownstream:

SELECT tblDest.DestID, tblNm.Nm, tjnDestPtf.PtfDestID, tblNm.NmTypeID
FROM tblNm INNER JOIN ((tblDest INNER JOIN tjnDestNm ON tblDest.DestID =
tjnDestNm.DestID) INNER JOIN tjnDestPtf ON tblDest.DestID =
tjnDestPtf.DestID) ON tblNm.NmID = tjnDestNm.NameID
WHERE (((tjnDestPtf.PtfDestID)=[Forms]![frmDestG]![lstSeparately]) AND
((tblNm.NmTypeID)=1))
ORDER BY tblNm.Nm;

The query on the first list box (lstSeparately) is identical except that it
refers to the combo in the WHERE clause.

I've tried Me!lstDownstream.Requery on various events on the form and
controls, but no luck.

Any ideas please.

Thank you

Peter

 

[Peter Stone]

I should have mentioned that all records are from the same table (tblDest)
which has a self join.

Peter

 

[Peter Stone]

Thanks-but unfortunately, I had tried that (and just tried it again).