Dbcombo

[CoMMiE]

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

[lukePas]

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

[CoMMiE]

Thanks for the help lukePas