Hi,
I have attached a test database that can be viewed by the experts... Though i'm not confident i'll solve this, as I think it's another inherent bug that microsoft can't seem to get their dev team to fix.
GOAL:
I am trying to create a listbox selection that changes a "view". Each view is a subform or tab control. It doesn't matter at this stage. The point is, I want to switch between forms with a vertical listbox, much like you see it many applications today.
Requirements:
This is where it gets tricky
--The listbox selection MUST not scroll with the screen and MUST be vertical to the left side.
--Each "view" or page must be able to scroll independently of the main form background (i..e listbox)
--Each page must be held in memory (this leaves Navigation controls out of the question - they are useless and cumbersome anyhow)
--Each "page" or "view" must ALSO be able to hold one additional tab control (thanks Microsoft for not developing nested tab controls) - this is achieved by using a subform that contains a tab form inside.
Current approach:
I am using a tab control to store the "views". Each tab is controlled with the listbox. In each tab, a subform is loaded. Within that subform, a tab control may or may not exist. Along with the necessary controls for that page.
Current Problem:
Because i need the listbox to remain stationary and also vertical on the main form, I have set the main form's scroll property to None. This presents an issue with a subform. The subform scrolls an arbitrary amount. It does NOT allow scrolling within the subform clear to its bottom. To get to the bottom of the subform, you must scroll the main form. And this is an issue.
Conclusion:
These are semi-fundamental functions of software design that can't be achieved.
I'm curious to see if anyone has a solution. Please see my attached DB. Thanks for your time.
UPDATE:
Accessforums not allowing me to upload my .accdb. Says file upload failed, but no reason why (nice feature).
Please DL from here: http://s000.tinyupload.com/?file_id=69181178471278011452