I have a Continuous Subform on my Main Tabbed form.(See image below)
[image ]
[image ]
When the user clicks this Tab, I need the subform to open and automatically display a row for each of the values in dropdown box Combo12. (Combo12 is based on a Table that curently has 10 items in it but will grow in the future)
I do not care if this is a drop-down or text box field as the user will not be allowed to change.
To make it easier for an end user to input the Totals, how do I have this subform open, with a row for every item in my table that isn't discontinued? (This table has the following fields, ID, Desc, & Discontinued checkbox)
[image ]
Thanks for your help, Hope this is enough information.
[image ]
[image ]
When the user clicks this Tab, I need the subform to open and automatically display a row for each of the values in dropdown box Combo12. (Combo12 is based on a Table that curently has 10 items in it but will grow in the future)
I do not care if this is a drop-down or text box field as the user will not be allowed to change.
To make it easier for an end user to input the Totals, how do I have this subform open, with a row for every item in my table that isn't discontinued? (This table has the following fields, ID, Desc, & Discontinued checkbox)
[image ]
Thanks for your help, Hope this is enough information.