Hello there,

i'm working on a recordset.Open (sql statement)

st.Open "select * from qns_table, ans_table, ss_table where (some conditions)", cn, adOpenDynamic, adLockOptimistic

and i'm adding them into a list box

Me.List3.AddItem rst!ansID & ";" & etc...etc... (take note of ansID)

the problem lies at 'ansID' being part of ans_table, as well as ss_table and when i add rst!ansID, the application gets confused because it doesn't know if this ansID belongs to either ans_table or ss_table.

i have tried alternative methods
i.e, rst!ans_table.ansID - apparently the syntax is not correct.

can someone shed light here?

Thank you very much =)

Astro