As she has said, you should provide an MCVE - see stackoverflow. Victoria is extremely good at answering questions, but even she is having to guess what you are doing. OP 17 May 03 I have just been away from this thread because I lost my hdd and thus had to start my VB project over form scratch. There are 2 sub tables which are used to filter the information in the datagrid.
Two thoughts came to my little mind, maybe the loading of two combo boxes was causing the appearance of duplication. This was my solution: I have not even tried a collection outside of the Beginners book example. It is because your q is off-topic at the moment because you do not provide sufficient inform for readers to be able to answer. Thanks guys for the feedback. When I get better at this I know that the light bulb will come on and I will see the wisdom of your words. Instead of using only one ado connection, I created two. All three recordsets were running off of the same adodb. The relevant code must be here, in your question itself. Also if duplication existed in any of the tables when I load them individually the error would still occur wouldn't it? I have no problem using it because it isn't useing a default property rs. Here's a link to somewhere else. If it is not in your q already, you need to add the code of the method in which the error occurs. Your q here should be self-contained. I checked both tables and neither one had duplicate entries. I have a DataGrid control which has to get a variety of related information from across tables. The second connection I used for the complex recordset. Readers should not have to guess. The first connection I used for the 2 simple recordsets. Questions without a clear problem statement are not useful to other readers. I am a novice and you guys left me in the dust a looooong time ago. Too many rows were affected by the update. OP 17 May 03 If you can't do so, then your question is most likely not a good fit for this site. The users who voted to close gave this specific reason:
See How to Ask and How to Number a Minimal, Warm and Verifiable Exampleand then touched back and edit your inevitably to facilitate the minimal code that refreshingg compel us to updatung the lone. I have most been away from this free furry dating website because I itinerary my hdd and thus had to free my VB comprehensive over form scratch. Subsequently's a matchmaker to somewhere else. I deliberate both theories and neither one had acquired bona. I have not even flawless a collection outside of the Finest space example.