 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2007refresh with a toggle button
Ok this is going to be a stupid Q but so far what im trying doesnt work. I am using a toggle button which when clicked brings up some hidden text boxes to enter or view details, what I want to do is when the button is clicked again to make them invisible I want the page to refresh itself, so far I have been using... DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 on the on click and after update on the button but neither seem to work, any ideas? Thank You First, you need to drop the Dark Ages code. It is almost impossible to read and understand. Here is a quick example I threw together. Start by making all the text boxes and tier lables visible properties No in design view. Then use this code as an example and change the name to use your actual names: Private Sub Toggle0_Click() With Me .Text1.Visible = .Toggle0 .Text3.Visible = .Toggle0 .Label2.Visible = .Toggle0 .Label4.Visible = .Toggle0 End With End Sub  SignatureDave Hargis, Microsoft Access MVP > Ok this is going to be a stupid Q but so far what im trying doesnt work. > I am using a toggle button which when clicked brings up some hidden text [quoted text clipped - 8 lines] > > Thank You Hi that is code to make stuff visible, I am looking to refresh the page, the code I put is what access shows up as code to refresh if you use the wizard. I need to refresh the whole form whenever I click the toggle button >First, you need to drop the Dark Ages code. It is almost impossible to read >and understand. [quoted text clipped - 17 lines] >> >> Thank You Not a problem, just add Me.Refresh to the code. SignatureDave Hargis, Microsoft Access MVP > Hi that is code to make stuff visible, I am looking to refresh the page, the > code I put is what access shows up as code to refresh if you use the wizard. [quoted text clipped - 22 lines] > >> > >> Thank You Thank You Didnt remeber the Me. bit >Not a problem, just add Me.Refresh to the code. >> Hi that is code to make stuff visible, I am looking to refresh the page, the >> code I put is what access shows up as code to refresh if you use the wizard. >[quoted text clipped - 22 lines] >> >> >> >> Thank You |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.