>Hi,
> i have an query that use UNION. How could I query the certain records from the exisitng recordset?
>
>select * from table1 where condition A = true
>UNION
>select * from table2 where condition B = true
>UNION
>select * from table3 where condition C = true
>
>(REFERENCE BY MYRS1)
>
>I need to get certain records only from MYRS1.
>
>Any ideas?
Which database access method? DAO? ADO?
The fastest way is to add WHERE clause to your SELECT queries (which you already do).
Once your recordset is open, if you use ADO, you can use the Filter property.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com