Hello, I wonder if anyone can help me. I am stuck on it for almost 3 weeks.
I have a table "JobDatabase" (which include all details of each job position), a dataentry form, a Search form. In my Search form, I had a list box and a combo box (include all departments), where staff can pull down the menu and choose the department to see the job positions within that department. Then, the result will show on the list box. Here is my VB for that step:
Now my next step is double click a selected item listed on the list box. If the staff double click one of the listed items, then a detail form (a form include all details of the selected jobposition) will pop out. I don't know what to do!!!!! Can anyone help me? Greatly appreciated.
Carol.
I have a table "JobDatabase" (which include all details of each job position), a dataentry form, a Search form. In my Search form, I had a list box and a combo box (include all departments), where staff can pull down the menu and choose the department to see the job positions within that department. Then, the result will show on the list box. Here is my VB for that step:
Private Sub combo0_Click()
RefreshList
End Sub
Private sub RefreshList()
Dim sql As String
Dim selectedDeptID As Integer
selectedDeptID = Me.Combo0.Value
sql = "SELECt Jobdatabse.JobID, JobDatabase.JobPosition, JobDatabase.Dept FROM JobDatabase "_ & "WHERE JobDatabase.Dept = " & selectedDeptID _ & "ORDER BY JobDatabse.[JobPosition]"
Me.List2.RowSource = sql
End Sub
It worked good! RefreshList
End Sub
Private sub RefreshList()
Dim sql As String
Dim selectedDeptID As Integer
selectedDeptID = Me.Combo0.Value
sql = "SELECt Jobdatabse.JobID, JobDatabase.JobPosition, JobDatabase.Dept FROM JobDatabase "_ & "WHERE JobDatabase.Dept = " & selectedDeptID _ & "ORDER BY JobDatabse.[JobPosition]"
Me.List2.RowSource = sql
End Sub
Now my next step is double click a selected item listed on the list box. If the staff double click one of the listed items, then a detail form (a form include all details of the selected jobposition) will pop out. I don't know what to do!!!!! Can anyone help me? Greatly appreciated.
Carol.