 |  |  |  |  |  |  |  |
Text box population from DBgrid. HELP!!
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
 |
hi there,
i ve got a visual basic project that is being linked to an access database.
i ve already got a search function working to populate text box's with the information from one table in the relational access database. i am using the ADODC control to connect to the database. what i have got now is a DBgrid control on there to display the information from another table in the database.
What i want to do is for the DBgrid to populate another set of text box's with the information that is related to the information that i searched for, using the ID number as the foreign key in the table that populates the Dbgrid.
sorry if this doesnt make sense but i have tried to explain it as best i can.
please any help would be good or any suggestions for that matter.
Thanx alot people
i ve got a visual basic project that is being linked to an access database.
i ve already got a search function working to populate text box's with the information from one table in the relational access database. i am using the ADODC control to connect to the database. what i have got now is a DBgrid control on there to display the information from another table in the database.
What i want to do is for the DBgrid to populate another set of text box's with the information that is related to the information that i searched for, using the ID number as the foreign key in the table that populates the Dbgrid.
sorry if this doesnt make sense but i have tried to explain it as best i can.
please any help would be good or any suggestions for that matter.
Thanx alot people
•
•
Join Date: Mar 2005
Posts: 71
Reputation: 
Solved Threads: 3
Junior Poster in Training
Hi,
i don't know if this what you need. Assuming you have text1 you can do like this:
Private Sub DataGrid1_RowColChange(LastRow As Variant, ByVal LastCol As Integer)
text1=adodc1.recordset("name")
End Sub
What this do is it will populate the text1 everytime you change your row.
hope it will help.
NewVBguy...
i don't know if this what you need. Assuming you have text1 you can do like this:
Private Sub DataGrid1_RowColChange(LastRow As Variant, ByVal LastCol As Integer)
text1=adodc1.recordset("name")
End Sub
What this do is it will populate the text1 everytime you change your row.
hope it will help.
NewVBguy...
|
Similar Threads
- writing from bottom up in rich text box (VB.NET)
- pass the value to the text box (JavaScript / DHTML / AJAX)
- Text Box Newbie help (Visual Basic 4 / 5 / 6)
- Text box question (C#)
- text is being written in text box (Web Browsers)
- Help with text box height (HTML and CSS)
- Cannot enter any text in a IE text-box (Viruses, Spyware and other Nasties)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Customised Menu
- Next Thread: Form Caption
| Thread Tools | Search this Thread |
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for Visual Basic 4 / 5 / 6
* 6 429 2007 access activex add age append application basic beginner birth bmp calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver subroutine table tags textbox time timer urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
