 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / December 2007Form Navigation
I have a form called “frmIncidentForm” that has a “Next Button”, “Previous Button” and “Add Button” The form will only allow editing of records within the opened form. I would like to disable the “Previous Button” and “Next Button” when the form is first opened. Then as records are added the “Previous Button” is enabled. If the user navigates backward the “Next Button” is enabled. Basically, I would like the buttons to only be enabled when there are records to navigate to. Pushrod, You can use the Current event of the form. Experiment with code something along these lines: Me.NameOfPreviousButton.Enabled = (Me.CurrentRecord > 1) Me.NameOfNextButton.Enabled = (Me.CurrentRecord < Me.RecordsetClone.RecordCount)  SignatureSteve Schapel, Microsoft Access MVP > I have a form called “frmIncidentForm” that has a “Next Button”, “Previous > Button” and “Add Button” [quoted text clipped - 8 lines] > Basically, I would like the buttons to only be enabled when there are records > to navigate to. 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
|
©2008 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.