I am very furstrated. I need to populate a field (Time) based off the selection of two different combo box. The first combo box (Tasks) finds all the tasks once selected based on the selection the second combo box populate related data to that criteria. Now I need the text field (Time) to populate based on both selections made. I will be disabling this field so that users only see the time and cannot change it. Can anyone help me out? Here is my setup and how it works so far.
I have 2 tables.
Details
DetailsID
CoachName
DateEntered
Division
Task
SubTask
Time
QuantityOfTask
Comments
OnSiteLocation
Grief
CombinedTaskServices
TaskID
ProjectName
TaskName
Bucket
Quantity
Unit
Time
OperationalDef
3 Queries
MasterQuery
SELECT DISTINCT CombinedTaskServices.ProjectName
FROM CombinedTaskServices;
SlaveQuery
SELECT DISTINCT ProjectName, TaskName
FROM CombinedTaskServices
WHERE ProjectName=forms!frmMain.cboProjectName.value;
TaskTimes
SELECT DISTINCT ProjectName, TaskName, Time
FROM CombinedTaskServices WHERE ProjectName=forms!frmMain.cboProjectName.value AND TaskName=forms!frmMain.cboTaskName.value;
Form
frmMain
Has all items on it from Details table. Both the Task and SubTask are combo boxes. The time is a text field.
I have programmed the Task combo...
Private Sub cboProjectName_Change()
Me.cboTaskName.Requery
Me.cboTaskName = ""
End Sub
Rowsource is:
SELECT MasterTasks.ProjectName FROM MasterTasks ORDER BY [ProjectName];
SubTask Rowsource is:
SELECT SlaveTasks.TaskName FROM SlaveTasks ORDER BY [TaskName];
Thanks!