in a form is there a way i can have a form which i can edit, and then toggle to view only (without being able to edit it?)
thanks

Hi Sabine

Thank you for your question regarding a read only form in Access.

There are several ways you can make this happen. You can do it through the form area or through a macro, depending on how you want to you want to use your database.

1. Form Level:
If you go to the properties of the page (right-click, properties), and then select FORM from the drop down window on the properties box, you will see 3 options:

- Allow Edits
- Allow Deletions
- Allow Additions

By setting these to the appropriate YES / NO setting, you can control how the form can be used.

OR

2.Macro Level:
Once you have a form designed and completed, you can use a macro to OPEN the form in ADD mode or READ ONLY mode. You do not need to set the Properties on theform like the method above. This works with any form.
to make this work, simply go to MARCOS under the objects list, and create a new macro.
In the left column, drop down the list and find OpenForm.
In the properties below, type the name of the form you want to open, and the mode that you want to use to view the form.

To use the macro, you will need to attach it to a button of some kind. Use either a switchboard, or Add a button to a form using a Command Button Control (look in your toolbox).

Let us know if that helps, and if we can assist you any further.

Regards

Richard
Microsoft Office Specialist

Hi Richard
What settings do i need to alter on the database so that more than one person can access it (it's on the server) and make changes where necessary?
Thanks
Sabine