Hi. Seems that this should be easy, but I have spent the last two days, trying every imaginable method and have encountered nothing but weird problems.
This is a To Do list database, I'll simplify the data for clarity. There are tasks (what you have to do) and two levels to categorize them, Level and SubLevel. Each Sublevel is associated with a Level so that you could have identical values in the SubLevel field, differentiated by their Level. Level is a unique value.
I have 3 Tables
tblLevel
LevelName
tblSublevel
LevelName
SubLevelName
tblTasks
LevelName
SubLevelName
TaskName
I want to have a continuous form--frmTasks listing all the Tasks, and I want to filter the Tasks by Level and SubLevel, at the same time. So only tasks in the sublevel of the level would show.
frmTasks
In Header
cboLevelName
cboSubLevelName
In Detail
txtTask
The RecordSet for the form would be a query.
qryTasks
tblTasks.LevelName
tblTasks.SubLevelName
tblTasks.TaskName
Then I would set criteria for qryTasks.SublevelName as Forms![frmTasks]![cboSubLevelName]
and for qryTasks.LevelName as Forms![frmTasks]!cboLevelName
This didn't work, even if I eliminated cboSubLevelName and tried to filter with just the Level. The results are, in fact, quite strange. The query returns no records at all yet the form shows all records in the table?
Would really appreciate any suggestions as to what I'm doing wrong or a better way to approach this. I have tried several other methods of accomplishing this but to keep it simple I've started the question out here.
Thanks for your time
This is a To Do list database, I'll simplify the data for clarity. There are tasks (what you have to do) and two levels to categorize them, Level and SubLevel. Each Sublevel is associated with a Level so that you could have identical values in the SubLevel field, differentiated by their Level. Level is a unique value.
I have 3 Tables
tblLevel
LevelName
tblSublevel
LevelName
SubLevelName
tblTasks
LevelName
SubLevelName
TaskName
I want to have a continuous form--frmTasks listing all the Tasks, and I want to filter the Tasks by Level and SubLevel, at the same time. So only tasks in the sublevel of the level would show.
frmTasks
In Header
cboLevelName
cboSubLevelName
In Detail
txtTask
The RecordSet for the form would be a query.
qryTasks
tblTasks.LevelName
tblTasks.SubLevelName
tblTasks.TaskName
Then I would set criteria for qryTasks.SublevelName as Forms![frmTasks]![cboSubLevelName]
and for qryTasks.LevelName as Forms![frmTasks]!cboLevelName
This didn't work, even if I eliminated cboSubLevelName and tried to filter with just the Level. The results are, in fact, quite strange. The query returns no records at all yet the form shows all records in the table?
Would really appreciate any suggestions as to what I'm doing wrong or a better way to approach this. I have tried several other methods of accomplishing this but to keep it simple I've started the question out here.
Thanks for your time