Solved

scrolling in subform on tab page and make other tabs not visible based on field value

Posted on 2016-11-16
2
26 Views
Last Modified: 2016-11-17
I have a form with a subform:

"main_form"
"my_subform"   several fields but the field i need value from is  "Amended"
Tabct12  
page1, page2, page3, page4

While i'm scrolling in the subform, and the field value for "Amended" = "Yes"

I need page2, page3 on the tablccontrol to be set to Visible = "No"

Thanks
fordraiders
0
Comment
Question by:fordraiders
2 Comments
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
ID: 41889997
try using the current event of the subform

private sub form_current()

if me.Amended = "Yes" then
  me.parent.Tabct12.page1.visible=true
 me.parent.Tabct12.page2.visible=true
else
  me.parent.Tabct12.page1.visible=false
 me.parent.Tabct12.page2.visible=false
end if

end sub
0
 
LVL 3

Author Closing Comment

by:fordraiders
ID: 41891615
thanx, what i had come up with..just checking to see if another way...Thnx rey !
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now