Form opening in edit mode

[Guest]

I have a form that is based on a query. The query extracts the master list
from the tool master. My understanding was that since the form is based on
query it would be read only. This is not happening . The form can be edited.

I need the user to view the form in read only. I tried opening the form
using a macro as read only but i have a filter option set and if i set read
only the filter does not work.

what can I do to have the form work as readonly and have the filter on. I
had used the FindAsUtype from Allen Browne example.

thanks in advance.

 

[Guest]

In the form set the AllowEdits Property to No, and the AllowAdditions
Property to No.

Or, when you open the form use in the command line
Docmd.OpenForm "FormName",,,,acFormReadOnly

As you find out, it is possible to edit the data in the query

 

[Marshall Barton]

I have a form that is based on a query. The query extracts the master list
from the tool master. My understanding was that since the form is based on
query it would be read only. This is not happening . The form can be edited.

I need the user to view the form in read only. I tried opening the form
using a macro as read only but i have a filter option set and if i set read
only the filter does not work.

what can I do to have the form work as readonly and have the filter on. I
had used the FindAsUtype from Allen Browne example.

Set the form's AddowEdits, AllowAdditions and AllowDeletes
properties to No.

 

[Guest]

Thanks Marshall and Ofer for your inputs.
The form does not work yet.

I have Set the form's AddowEdits, AllowAdditions and AllowDeletes
properties to No. and also tried the docmd.openform in edit mode. The form
does open in read only mode but I am unable to use my filter.

I have a filter set in the footer which searches for each feildname in the
table and filter the rows. I am unable to select any fields to filter and
type any value for searching how can i over come this.

Thanks again

 

[Guest]

I created a query again and based my form on the query and than added the
filter in the form footer. It worked this time.
The forms AddowEdits, AllowAdditions and AllowDeletes
properties are set to yes by default. But now the form is read only and i
am able to filter. I dont know what went right or wrong there.


thanks for your inputs.
Thanks Marshall and Ofer