Duplicating a Form for Viewing Only

  • Thread starter Thread starter dhstein
  • Start date Start date
D

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.
 
You can copy the form and save it with a different name, then
set it's Allow Additions and Allow Edits properties to No
 
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.
 
Back
Top