I have a subform (datasheet) inside a subform (single form) inside a form, and am only seeing one record in the datasheet subform.
I am creating a database of database jobs that need doing (basically a ToDo list). The main tables look like:
Databases <-1----m-> Jobs <-1----m-> Tasks
In the form, I click on the databases combo, to select which database I want to see jobs for. I then click the jobs combo in the single form subform to see the list of that database's jobs. When I select a job, the tasks should appear in the datasheet subform, but only one record does so.
From forum/web searches, I can report that:
Does anyone have any suggestions?
many tia
mcalex
I am creating a database of database jobs that need doing (basically a ToDo list). The main tables look like:
Databases <-1----m-> Jobs <-1----m-> Tasks
In the form, I click on the databases combo, to select which database I want to see jobs for. I then click the jobs combo in the single form subform to see the list of that database's jobs. When I select a job, the tasks should appear in the datasheet subform, but only one record does so.
From forum/web searches, I can report that:
- My linking between main & subforms is through the queries (not master/child fields), and running these queries after Debug.Printing them shows the expected numbers of rows.
I have set the default view of the datasheet subform to Datasheet - I tried setting this to Continuous, but it made no difference.
Does anyone have any suggestions?
many tia
mcalex