Steve,
what if you change your lookup SQL to

SELECT A.ACCNT_ID
, A.ACCOUNT
, A.SPEEDTYPE
, A.CLASS
FROM ACCOUNTS A
JOIN ACCNTHLDRS_ACCNTS AA
ON AA.ACCNT_ID = A.ACCNT_ID
JOIN ACCNTSUSED AU
ON AU.ACCNT_ID = AU.ACCNT_ID

or something like that. I'm not quite convinced it's the best way to do
things, but LookupCombos in a grid is pretty complicated and my brain
hasn't quite woken up today.

Set