Hi. My first visit here
I am trying to develop a database to assist with management of job numbers Each job number has at least one (or more) tasks associated with it. The tasks consist of two fields - Category and Description which are contained in a table.
I have set up a form which uses two combo boxes to read each field. The Category field has multiple occurrences and a SELECT DISTINCT statement is used in that combo to display a unique list. This works OK. A requery is coded for the afterupdate event: Description01Cmb.Requery
I have then used a query to select the Description field list based on the selected value of the Category field. The code is:
SELECT Task_Category_TBL.Description, Task_Category_TBL.Category FROM Task_Category_TBL WHERE (((Task_Category_TBL.Category)=Forms![Task_Register01_FRM]!Category01Cmb));
That Description field is passed to the Description combo via SELECT [Task_Register_QRY].[Description] FROM Task_Register_QRY;
When the above is set in a single form everything operates correctly. When it is set up as a subform the Description combo does not populate!
Hope that is clear enough. I was going to upload the db, but it is too big
Any ideas please?