Form is editable even after setting it to false

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Dataentry form that allows add/modify/delete data into this form.
Then I copied this form, changed the name to Search. Changed the form
properties for edits, delete, modify to false.

But when I open up the Search form, I am still able to edit/modify/delete data
in the form. I also tried enforcing it by setting Me.allowedits,
Me.allowdelete, etc.
to 'false', still this form allows data modifications, etc.

What am I doing wrong. Has anyone faced this problem? How to fix it?

Thank you,
-Me
 
Me said:
I have a Dataentry form that allows add/modify/delete data into this form.
Then I copied this form, changed the name to Search. Changed the form
properties for edits, delete, modify to false.

But when I open up the Search form, I am still able to edit/modify/delete data
in the form. I also tried enforcing it by setting Me.allowedits,
Me.allowdelete, etc.
to 'false', still this form allows data modifications, etc.

What am I doing wrong. Has anyone faced this problem? How to fix it?
Click to expand...


Assuming the OpenForm method's EditMode was not specified,
that can happen if the form's current record has already
been modified.

Regardless of that, I think your big mistake is binding the
search form. It is almost always wrong to use bound form
with bound controls as a search mechanism.
 
Hi Marshall,

Thank you for your reply!
I agree with you that binding is not a good idea, but how can I resolve it?
Morevoer, I am using similar forms, but didn't encounter it until this form.
Its happening only for this form thereofore I suspect something fishy.

Any leads will be highly appreciated.

Thank you,
-Me
 
are you setting the properties at design time to disable allowedit etc? The
form being bound really does not have anything to do with whether or not you
can edit it. But to be able to enter a search term, the Allowedit has to be
set to True. So it may be better to set Locked to false for each control on
the form that will just be used to display data.

Enjoy. j.
 
I really don't understanf how a bound form is supposed to
function as a search form. As Jen says, if AllowEdits is
set to No, then you will not be able to enter anything, even
your search criteria.

Maybe your form displays all the records in a table and
users just scroll through the records to "search" for the
one they want???

I think you need to explain how this "search" form is
arranged and what it is supposed to do.

Is the AllowEdits property preset in design view?

How is this form opened? If you are using a button on
another form, did you check if the OpenForm method's
EditMode argument has something specified?

Have you checked to make sure there is no code in the form's
Load or Current event that sets a field's value?
 
Hi Jen & Marshall,

Thank you both for taking time to reply!

In the my form's properties, I set allowadditons, allowdeletions,
allowupdate to false. I leave allowfilter to true. allowfilter lets users
enter the search criteria.

I have been using my search forms like this for years now. Due to time
crunch, this is the best way for us to quick apps and roll it out to users.

Maybe I am unable to put it clearly. Can you try creating a data entry form
and then
just convert it into say search form, just change this search form's
properties
of allowaddtions, allowdeletions, allowupdates to false and leave only
allowfilters to true. This will allow to you to do search without any code.

Let me know your findings.

In my case it has been working this way for quite some time, therefore, I
fail to understand why it won't work. I am still investigating.

Appreciate your support.

-Me
 
Back
Top