 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2007Set form's property when opening it
I would like to open a form by setting some properties: eg. using DoCmd.OpenForm "frmEmployee", acNormal, , , acFormAdd, acWindowNormal setting the record navigator visible/invisible Is it possible? Hi Alan You can set the navigation properties immediately after opening the form... DoCmd.OpenForm "frmEmployee", acNormal, , , acFormAdd, acWindowNormal Forms![frmEmployee].NavigationButtons = True or in the forms open even... Me.NavigationButtons = True If neither of these is suitable, then you could use the OpenArgs argument like... DoCmd.OpenForm "frmEmployee", acNormal, , , acFormAdd, acWindowNormal, "ShowNav" And then test for this in the forms open event... If Me.OpenArgs = "ShowNav" then Me.NavigationButtons = True Else Me.navigationButtons = False End If Regards Andy Hull > I would like to open a form by setting some properties: > eg. using [quoted text clipped - 3 lines] > > Is it possible? Hi, yes it works to make the Navigator buttons visible. Can I also configure the buttons visibility? I want to allow the user navigate the records but not add records. Can I disable the * button? > Hi Alan > [quoted text clipped - 31 lines] >> >> Is it possible? Again, in the forms open event... Me.ButtonName.Visible = False  SignatureThere's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 In the forms open event... Me.NavigationButtons = True Me.AllowAdditions = False will allow navigation but not allow new records (it greys out the *) Regards Andy Hull > Hi, yes it works to make the Navigator buttons visible. > [quoted text clipped - 37 lines] > >> > >> Is it possible? Thanks. That is what I want. > In the forms open event... > > Me.NavigationButtons = True > Me.AllowAdditions = False |
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.