If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Make form look the same as when opened
I have SubForm where I am moving controls using "Left" and "Visible"
properties depending on the value of a control on the Main Form. I want to reset the form so all of the controls will have their default values, as they were when the SubForm was opened. Is there a way to do this? And if so, where would this code go? |
#2
|
|||
|
|||
Make form look the same as when opened
iamnu,
You'll have to reverse your Left and Visible code in order to get your controls back to where you started... during that form session. If something about the value of a "control on the main form" caused you to move those controls left, then something about the value of "a control on the main form" should cause you to reset the controls to their original position. Example... main form control = [SomeValue], and... using the AfterUpdate of the control on the main form... If [SomeValue] =100 Then 'move controls left, and make visible Else 'move controls right, and make invisible End if -- hth Al Campagna Microsoft Access MVP 2006-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "iamnu" wrote in message ... I have SubForm where I am moving controls using "Left" and "Visible" properties depending on the value of a control on the Main Form. I want to reset the form so all of the controls will have their default values, as they were when the SubForm was opened. Is there a way to do this? And if so, where would this code go? |
Thread Tools | |
Display Modes | |
|
|