Jim Lawrence
accessd at shaw.ca
Mon Mar 10 23:57:43 CDT 2008
Hi Darryl: You have run into the problem that many before you have collided with. The person that could best help with this is John Colby.... he is probably asleep now. He has perfected a JIT system that does not populate the tab with objects until the tab is selected. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins Sent: Monday, March 10, 2008 9:24 PM To: Access Developers discussion and problem solving Subject: [AccessD] TabControlSheet Page Event? Hey all, I am stuck on with this, It is probably easy but been up since 4am (it is now 3:20pm) so I am not the sharpest tool in the shed right now! I have a form with sheet tabs, currently when a user opens the form it is populating all the tabs with data, but this seems a lot of overhead as some users will only look at one or two of the Tab pages. I wanted to capture when a user click on the tab page so I can call some VBA that will load the sub forms for that page only. I have the code to populate the sheet tabs etc, but I cannot seem to capture the "click on page tab" event at all. I can get "Click on TabControlSheet" but that is for the whole sheet and/or other such unhelpful combos of events. I thought this would be simple, but maybe I am wrong? '------------------------------------------------ ' Something like: Private Sub TabControlSheet.Pages(2)_Click() ' Then call the modules I want End sub '------------------------------------------------ would be great, but that doesn't seem to be an option. Any advice? cheers Darryl. This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses. No warranty is made that this material is free from computer virus or any other defect or error. Any loss/damage incurred by using this material is not the sender's responsibility. The sender's entire liability will be limited to resupplying the material. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com