1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2003
    Atlanta, GA
    Rep Power

    Need help with data connection + text box output

    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.

    Last edited by DTFan; July 2nd, 2003 at 05:05 PM.

IMN logo majestic logo threadwatch logo seochat tools logo