access_numpty
New member
- Local time
- Today, 12:04
- Joined
- Jan 12, 2009
- Messages
- 7
I have a query which combines three tables of data. There is a location table which has details of the item - which then leads to another table based on the items at that location.
The locations are unique and would never need to be added to. For each location you can have multiple items of information.
If I use the form wizard on the query it creates a subform of the data. Where all the locations are shown, and the subform shows the items at each location.
This is what I want!
However, I want to use a filter on the query so I can have two different forms above showing slightly different information based on an item type. When I filter the query - the form wizard won't create a subform, it just lists all the records at each location seperately.
How can I make it do what I want?
The locations are unique and would never need to be added to. For each location you can have multiple items of information.
If I use the form wizard on the query it creates a subform of the data. Where all the locations are shown, and the subform shows the items at each location.
This is what I want!
However, I want to use a filter on the query so I can have two different forms above showing slightly different information based on an item type. When I filter the query - the form wizard won't create a subform, it just lists all the records at each location seperately.
How can I make it do what I want?
