![]() |
Optionbuttons in frame on form
Hi, i have a large frame "Comparisons" and within that frame i have 5
smaller frames with two opiton buttons in each frame, these smaller frames are named from "2006" to "2011". I am trying to do an if statement to check the date and if 2006 then make frame2008.enabled=false, including the contents. In other words is it possible to "connect" the option buttons to the frame ?? Could you please give me some suggestions/help. thanks in advance.. Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
Optionbuttons in frame on form
if year(date) = 2006 then
frame2008.Enabled = False end if worked fine for me. The optionbuttons in 2008 are not grayed out, but they are disabled nonetheless. -- Regards, Tom Ogilvy "Les Stout" wrote: Hi, i have a large frame "Comparisons" and within that frame i have 5 smaller frames with two opiton buttons in each frame, these smaller frames are named from "2006" to "2011". I am trying to do an if statement to check the date and if 2006 then make frame2008.enabled=false, including the contents. In other words is it possible to "connect" the option buttons to the frame ?? Could you please give me some suggestions/help. thanks in advance.. Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
Optionbuttons in frame on form
Thanks Tom, that is my code also. My bad as i did not try it but just
saw that they didi not grey out. best regards, Les Tom Ogilvy wrote: if year(date) = 2006 then frame2008.Enabled = False end if worked fine for me. The optionbuttons in 2008 are not grayed out, but they are disabled nonetheless. -- Regards, Tom Ogilvy "Les Stout" wrote: Hi, i have a large frame "Comparisons" and within that frame i have 5 smaller frames with two opiton buttons in each frame, these smaller frames are named from "2006" to "2011". I am trying to do an if statement to check the date and if 2006 then make frame2008.enabled=false, including the contents. In other words is it possible to "connect" the option buttons to the frame ?? Could you please give me some suggestions/help. thanks in advance.. Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
All times are GMT +1. The time now is 03:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com