MAKING A READ-ONLY FORM

[sam1967]

What is the best way to make a read-only form (the form can be used
to view data but not change the data in any way).

 

[Kevin3NF]

Create the form and set the following properties of the form to NO:

Allow Edits
Allow Deletions

Kevin3NF

 

[mark]

Why don't you just create a report which is, by
definition, read only?

 

[sam1967]

Create the form and set the following properties of the form to NO:

Allow Edits
Allow Deletions

i did that - also Allow Additions - and it worked great.
only problem is I had a jump to record control using a combo box (it
jumped straight to the record id you typed in) and it stopped working
.. any idea why ?

 

[John Vinson]

What is the best way to make a read-only form (the form can be used
to view data but not change the data in any way).

Set its AllowEdits property to True; or (or also) open its
Recordsource and save it as an uneditable query. One simple way to do
so if the table isn't too big (performance hit!) is to make it a
Totals query and just group by all fields.

 

[sam1967]

Why don't you just create a report which is, by
definition, read only?

good idea. would that allow me to view each record a page at a time
and to implement a "jump to record" feature ?

 

[Ken Snell]

John - Did you mean to set AllowEdits to False?

 

[John Vinson]

John - Did you mean to set AllowEdits to False?

oops!

Quite correct, thanks for the catch!

 

[Dirk Goldgar]

i did that - also Allow Additions - and it worked great.
only problem is I had a jump to record control using a combo box (it
jumped straight to the record id you typed in) and it stopped working
. any idea why ?

Unfortunately, when you tell Access that a form can't be edited, Access
takes that to mean that *none* of the controls on the form are allowed
to be changed by the user; not even unbound controls. This is
annoying, as it means handy gadgets like your "jump to" combo won't
work. There are two ways you might solve that problem:

1. You could set the form's AllowEdits property to Yes, but also set the
Locked property of each bound control on the form to Yes. Then the user
couldn't change those controls, but you could leave the "jump to" combo
unlocked.

2. You could tinker with the form's recordsource query to make it
nonupdatable, as John Vinson mentioned.