[RESOLVED] VB6 + ADODC = Terrible headache! Please please please help me...!

[IHappenToBe]

Oh God this is KILLING ME!!

First of all, please don't tell me I didn't bothered searching for an answer in other posts. I've spend 2 whole days seeing if my problem was already solved in other threads/posts.

So please be gentle and try to help me.

My problem is the following:
* I'm using vb6, ADODC and DataGrid
* I ALREADY have loaded in my form the ADODC (already and correctly linked to my database), the DataGrid (already and correctly linked to the ADODC) and some other TextBox linked as well with ADODC.
* Everything is fine, it all works perfectly. NOW: I just want to give to my ADODC the simplest SQL instructions, and I don't know how, beacuse all the info I got from VBForums is regarding NEW Ado controls, (not previously loaded).

Please, note that I already know what commands I want to send to ADODC, and I already know how to do it with new controls.
I also know how to set the ADODC with a starting SQL instruction, via ADODC's Properties

You may ask why I want to know this if I already know how to do it with new controls. It's because it's so easy to just set the ADODC from VB, not via code. I just put it in the place I want it, the size I want it, to select via browser... to link TextBoxes and it all works so neat, so automatically... Come on! It has to be a simple way, something like:
ADODC1.RecordSet.DO SQLInstr

Thank you, and please excuse any mispellings or grammatical errors, english isn't my motherthonge.