Results 1 to 5 of 5

Thread: Coding the ado to a textbox!

  1. Mar 27th, 2000, 10:08 PM #1
    VBAmateur
    VBAmateur is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 2000
    Location
    Greenville
    Posts
    73
    Ok I simply now need to assign these textboxes to a new ado when a datagrid gets focus IN CODE. I cannot get the syntax right, anyone have a example.

    IE: Datagrid2_gotfocus
    txt1.text = (adodc3 and hooks to the CusName Datafield)

    Whats the Syntax??? Danke!
    Reply With Quote Reply With Quote
  2. Mar 27th, 2000, 10:12 PM #2
    bsmith
    bsmith is offline
    Lively Member
    Join Date
    Jan 2000
    Location
    Springfield, IL
    Posts
    124
    Are you wanting to access a recordset that you already have open?
    Reply With Quote Reply With Quote
  3. Mar 28th, 2000, 12:01 AM #3
    VBAmateur
    VBAmateur is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 2000
    Location
    Greenville
    Posts
    73
    YES
    Reply With Quote Reply With Quote
  4. Mar 28th, 2000, 12:05 AM #4
    bsmith
    bsmith is offline
    Lively Member
    Join Date
    Jan 2000
    Location
    Springfield, IL
    Posts
    124


    txt.text = rs.Fields("CusName").Value


    rs is the name of the recordset that you have open.

    Reply With Quote Reply With Quote
  6. Mar 28th, 2000, 12:09 AM #5
    bsmith
    bsmith is offline
    Lively Member
    Join Date
    Jan 2000
    Location
    Springfield, IL
    Posts
    124
    Also check out the ADO data control in the MSDN. Under the ADO data control there is a recordset property. This may be what you were asking for. Sorry for taking you the long route if it was.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width