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


P

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
 
Ad

Advertisements

P

Peter Stone

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

Peter
 
Ad

Advertisements

P

Peter Stone

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top