query for recordsource of listbox keeps changing

[bobmac-]

Hi,

I have a query with a sub query, all based on one table (attached).
The query is a record source for a listbox.

Two things occur; Firstly, the query SQL below changes as indicated after trying to use it. Secondly the Form upon loading says the query doesn't exist.

This is very frustrating, any ideas?

Before
SELECT tblOffer_New_Outlet_Type.on_outlet, B.obj_value, A.obj_value, tblOffer_New_Outlet_Type.on_date_set
FROM (((tblobject AS A) INNER JOIN ((SELECT * FROM tblobject) AS B) ON A.obj_id=B.obj_id) INNER JOIN tblOffer_New_Outlet_Type ON A.obj_id=tblOffer_New_Outlet_Type.obj_id) INNER JOIN tblOffer ON tblOffer_New_Outlet_Type.offer_id=tblOffer.offer_id
WHERE (((B.oba_id)=20) And ((A.oba_id)=21) And ((tblOffer.pro_id)=Forms!frmProposal!txtProId))
ORDER BY tblOffer_New_Outlet_Type.on_date_set DESC;

After
SELECT tblOffer_New_Outlet_Type.on_outlet, B.obj_value, A.obj_value, tblOffer_New_Outlet_Type.on_date_set
FROM ((tblobject AS A INNER JOIN [SELECT * FROM tblobject; ] AS B ON A.obj_id=B.obj_id) INNER JOIN tblOffer_New_Outlet_Type ON A.obj_id=tblOffer_New_Outlet_Type.obj_id) INNER JOIN tblOffer ON tblOffer_New_Outlet_Type.offer_id=tblOffer.offer_id
WHERE (((B.oba_id)=20) And ((A.oba_id)=21) And ((tblOffer.pro_id)=Forms!frmProposal!txtProId))
ORDER BY tblOffer_New_Outlet_Type.on_date_set DESC;