Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Open Access Form in Read only mode

Status
Not open for further replies.

tlaksh

Programmer
Feb 25, 2001
98
US
I want to be able to open a master detail form in read only mode when the form starts up so that the user cannot change data by mistake. If the change the data mode property this disables the add & delete buttons. Also how do i get the user to edit mode if required.

Please help

Thanks
Lakshmi.
 
Hello

There are three form properties:

AllowEdits
AllowAdditions
AllowDeletions

that disable/enable the editing, addding and deleting of records from the form as a whole.

What you need to do is to put a button on the form that toggles the properties as appropriate. Remember that they must be set as disabled in the form design or in the Form_Load event to stop people editing the data before the button gets clicked.

John
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top