Hi

I have a question about how to eliminate duplicate data from VB6 . I am developing a application where I have a access 2.0 database and VB6 as front end . When I run the application data come from that databse to the form . I like to eliminate the duplicate data from the from which is coming from the access database . I have used DISTINCT key word in the VB code and it did not work . I have tried the DISTINCT in the query analyser and it worked . I like to know how to write VB code to eliminate the duplicates . I can not write stored procedure as access 2.0 does not support that ( or may be I do not know that . Please let me know if Access 2 does support stored procredure ) . Please so me some code . The database connection is working

Thanks