open form as read only but allow filters

[Misiek]

Hello,

I have a button that open a form

 DoCmd.OpenForm FormName, , , , acFormReadOnly

form opens as read only and everything is as it should be.

In the footer of this form I have filters and I need to be able to use them.

Is it possible to have form opening in read only for DETAIL section but allow to apply filters in FOOTER section?

Thanks

 

[Wiggi.exe]

If the form is always going to be set up this way, why not try this:
Set the properties of the Form:
Allow Additions = No
Allow Deletions = No
Allow Edits = No

and then set the property:
Allow Filters = Yes

 

[Misiek]

Yes that could work but I use this form couple of times with different preferences so can't do it.
Any other possibilities?

 

[Misiek]

Any other suggestion please?

 

[gemma-the-husky]

instead of just setting allowedits = false, (which is a bit of a blunt instrument) iterate the controls and make the text boxes etc enabled/locked as necessary. that way the filter will still work.

alternatively maybe you can put the filter instruction on a button click.