What I am trying to do is simple. I have 3 combobox's on one form.
-cboSystem
-cboRelease
-cboProject
Now, based on what I select in cboSystem, the values in cboRelease & cboProject should be filtered.
Also, there are 2 tables:
-Release(ID,System,Release)
-Project(ID,System,ProjectName)
I would like to mention that , i have used below code to filter cboRelease based on cboSystem.
Expand|Select|Wrap|Line Numbers
- Dim stRelease As String
- stRelease = "SELECT [Release].[ID],[Release].[ReleaseName] FROM Release WHERE [Release].[System] = '" & Me.cboSystem.Value & "';"
- Me.cboRelease.RowSource = stRelease
- Me.cboRelease.Requery
Expand|Select|Wrap|Line Numbers
- Dim stProject As String
- stProject = "SELECT [Project].[ID],[Project].[System],[Project].[ProjectName] FROM Release WHERE [Project].[System] = '" & Me.cboSystem.Value & "';"
- Me.cboProject.RowSource = stProject
- Me.cboProject.Requery
"Enter Parameter Value" Project.ID=
Project.System=
Project.ProjectName=
At last cboProject displays nothing but blank.
Before selecting anything all the combobox's are displaying all information(unfiltered).
I guess i gave required informations.
I just want to figure out what mistake i have done in the coding.
I would appreciate all kind of help.
Thank you :)