Hi
How can i make the Dbcombo go to the require row of records when the user select a data inside the Dbcombo?
Any help and suggestion will be greatly appreciated
Printable View
Hi
How can i make the Dbcombo go to the require row of records when the user select a data inside the Dbcombo?
Any help and suggestion will be greatly appreciated
I'm not to sure exactly what you want this may be worth a try - or I could be completely wrong!!
set the bound column of the DbCombo to the Id number
Then simply execute an SQL statement like follows
adoVerse.RecordSource = "SELECT Verse.[Verse ID], Verse.heading, Verse.verse FROM verse INNER JOIN [song verses] ON verse.[Verse ID] = [song verses].[Verse ID] WHERE [song verses].[Song ID] = " & Val(frmHomeDisplay.txtSelected.Text)
Call adoVerse.Refresh
or more simply
adoVerse.RecordSource = "SELECT * FROM [table] WHERE tableID = " & Val(cboData.boundColumn)
Call aboVerse.Refresh
hope that could be of some use
Thanks for the help lukePas :)