janith CPA Local time Today, 09:17 Joined Apr 11, 2012 Messages 65 Sep 26, 2015 #1 Hi I'm trying to set up a tab which should only be visible on load form function based on a text field value. Can someone suggest the VBA choose for this?
Hi I'm trying to set up a tab which should only be visible on load form function based on a text field value. Can someone suggest the VBA choose for this?
L llkhoutx Registered User. Local time Yesterday, 22:47 Joined Feb 26, 2001 Messages 4,018 Sep 26, 2015 #2 If me.txtname = {whatever} then me.pagename.visible = true else me.pagename.visible=false end if
janith CPA Local time Today, 09:17 Joined Apr 11, 2012 Messages 65 Sep 26, 2015 #3 Will this be part of on load form?.. Will help if you can provide the complete code.. Sorry
L llkhoutx Registered User. Local time Yesterday, 22:47 Joined Feb 26, 2001 Messages 4,018 Sep 26, 2015 #4 Use it on the form Load event or on the me.txtname_AfterUpdate event, probably the latter unless you have a bound form. I gave you the complete code.
Use it on the form Load event or on the me.txtname_AfterUpdate event, probably the latter unless you have a bound form. I gave you the complete code.
