I'm trying to create a form which will have an ADO connection to an Access 2000 database. I've used the ADODC to make the connection to the database. I can use the DBGrid to output the results of the query I typed in the recordsource. By the way, everything I just said took me about 3 hours to do.
I DON'T know VB 6.0 at all.
What I would like to do is be able to run the query and then have the results output into 2 text boxes. The database has a table called "tblCustomer". This table has two fields, custFirstName and custLastName. I would like to be able to run the query (using a command button) and have the results (if there are any) output to two text boxes, named "txtFirstName" and "txtLastName". Oh, and I named the data connection "DataConnection1" (instead of the default ADODC1).
I've tried everything I can think of but like I said, I am totally new to this. If you can help, please make your explanations as simplistic as possible so that I don't get lost.
Thanks again.
DTFan