On Form Opening

[johnbird1988]

Hello
I have created a switchboard and on the switchboard there are various buttons that opens form once clicked. One of the buttons just opens a form normally and I would like another button once clicked to open the same form but change the form properties so that “Data Entry = Yes” and “Navigation Buttons = No”.
I need this change to only apply when this button is clicked and act normal when others activated.
Thank you for your help
John

 

[Montez659]

You will want to trigger some VBA code when doing this. In the On Click (not 100% sure if this is the right Event as I rarely use a switchboard) create an Event Procedure and the following code will go there:

DoCmd.OpenForm "YourFormName"
Forms("YourFormName").NavigationButtons = False
Forms("YourFormName").AllowAdditions = False

Of course you can switch False to True for the other button.

This is the general idea and you will have to play around with it a bit becuase I am not sure how the switchboard triggers events, whether it is a Macro or VBA (probably a Macro, but if all it is doing is opening a form, this would replace the Macro). As always, make a copy of the switchboard in case these changes mess stuff up.