nhorton79
Registered User.
- Local time
- Today, 14:34
- Joined
- Aug 17, 2015
- Messages
- 147
Hi All,
I want to be able to have a list of items display on multiple tabs on a form, but each list of items to be filtered to the type of tab.
I have created a test form with a tabcontrol on it and managed to get the tab names (captions) defined from the records in a table.
I want them defined this way so that in future I can add additional tab names in the table and have them automatically generate on the form without having to edit the form and release a new version of the database.
So this part is sorted, however, this is where I come unstuck.
I want to have a copy of the same subform on each tab (one again, so that I don't have to edit and release new versions just to add an additional tab).
Each subform (a continuous form) will display "Item" records related to the job, filtered/joined on tblJob.JobID and tblItem.JobID_FK, however, I would also like to filter each one based on the tblItem.ItemTypeID_FK
I've attached a stripped down copy of the database with only the main form, subform and necessary code/tables to display.
If someone was able to assist that would be great.
I want to be able to have a list of items display on multiple tabs on a form, but each list of items to be filtered to the type of tab.
I have created a test form with a tabcontrol on it and managed to get the tab names (captions) defined from the records in a table.
I want them defined this way so that in future I can add additional tab names in the table and have them automatically generate on the form without having to edit the form and release a new version of the database.
So this part is sorted, however, this is where I come unstuck.
I want to have a copy of the same subform on each tab (one again, so that I don't have to edit and release new versions just to add an additional tab).
Each subform (a continuous form) will display "Item" records related to the job, filtered/joined on tblJob.JobID and tblItem.JobID_FK, however, I would also like to filter each one based on the tblItem.ItemTypeID_FK
I've attached a stripped down copy of the database with only the main form, subform and necessary code/tables to display.
If someone was able to assist that would be great.