Hi there, i am facing a real problem, I created 2 tables.
Movies(MovieID, MovieCategoryID, Title, ratings ...)
I have populated the MovieCategory tables with some data, and i want to test out my Movie form that i have created.
In my Movie form as attached in the screenshot, i have to fill in all the relevant movie details, however, i populated a dropdownlist from the MovieCategory table showing the Categoryname.
The problem that i face now is i want to enter the Movie datas into the movie table, but my dropdownlist is populated with the CategoryName, i need to change it to its repective MovieCategoryId but i am unable to do this. I have tried lots of methods but i still can't figure out how to solve this. Will really need some help here.
The code attached below is something that i have tried, but to no avail. Can anyone please advice me on how to go about it?
Private Sub ddlCategoryName_Change()
Dim strOne As String
strCatName = Me.ddlCategoryName.SelText
Dim strSql As String
strSql = "SELECT MovieCategoryId FROM MovieCategory WHERE CategoryName =" + strCatName
Me.ddlMovieCategoryId.RowSource = strSql