im working on vb 2010 and ms access db..
just want to ask if a textbox with databinding can be used to search or filter data and display it to other textboxes with databinding on the same form? thank you..
shann1718
0
Newbie Poster
Recommended Answers
Jump to PostYes it can be done. Use your recordset to search for the criteria, once found, add each field value into its respective textbox.
Jump to PostYou will have something like this -
rsData.Open "SELECT * FROM YourTableNameHere WHERE YourFieldNameToSearchHere = '" & Text1.Text & "'", cnYourConnection, adOpenStatic, adLockOptimistic Text2.Text = rsData!WhatEverResultYouGot ''etc....
All 7 Replies
AndreRet
511
Senior Poster
shann1718
0
Newbie Poster
AndreRet
511
Senior Poster
Netcode
33
Veteran Poster
shann1718
0
Newbie Poster
AndreRet
511
Senior Poster
shann1718
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.