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.

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

Sean Bailey


"dhstein" wrote:

> 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.

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.
--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand


"dhstein" <(E-Mail Removed)> wrote in message
news:195B0816-5530-4778-97C2-(E-Mail Removed)...
>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.