Duplicating a Form for Viewing Only

[dhstein]

I have a form that the user can use to update product information. The
fields are mostly editable - with a few exceptions. I'd like to provide a
duplicate of the form just for viewing purposes - without the fields being
editable. Do I need to create another form for this from scratch or is there
some way of copying the original form? Thanks for any help on this.

 

[Beetle]

You can copy the form and save it with a different name, then
set it's Allow Additions and Allow Edits properties to No

 

[Graham Mandeno]

You don't even need a second copy of the form. Just modify the code that
opens the form to open it read-only:

DoCmd.OpenForm "YourForm", DataMode:=acReadOnly

If you want finer control - for example, make some controls editable but not
others - then you can write code to modify the Locked and/or Enabled
properties of these controls on the fly after the form is opened.