Union Query and retrive fromVisual basic

[SAKTHIVEL]

Hi,
Im developing applications using Visual Basic and MS-Access 2003. Union query solves my specific problems. But I unable to call this query from visual basic form like other queries.
The query follows:[ Named as VwPSCLNo]

select PSCLNo,Fyearid,CompId, "CLNO" as TrType from VwCLothsrNo
UNION
select PSCLNo,Fyearid,CompId, "PSNO" as TrType from VwPSsrNo;


Visual Basic Form Statement:
-----------------------------
Dim Crs as adodb.Recordset
Set Crs = New ADODB.Recordset
Crs.Open "select * from VwPsClNo ", GCon, adOpenKeyset, adLockReadOnly
Text1.Text = Crs.Fields(0).Value
--------------------------
Error Message:
ODBC driver doesnot support the requested properties.
---------------------------
Note:
Im using DSN for ODBC connectvity and Microsoft Jet 4.0.

please help solve this issue.

Regards,
Sakthivel.N

[PEB]

So what I see: your query's name is: VwPSCLNo
And You try to open VwPsClNo without ";" ;):);)

I hope that this is the problem ;)