Unable to Change Data on Form

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

For some reason, on only one of my forms, I am unable to
edit the data. I have checked and there are no record
locks or sharing issues. What else can it be? Note that
all my other forms are perfectly fine. Thanks.
 
A couple of possibilities come to mind, Sharon ...

1. The AllowEdits property of your form may have inadvertently been set to
False.

2. The Record Source of your form may be a query that is not updateable;
i.e., it has Groups or Totals in it, among other things. To test this, open
the query itself and see if you can edit data in it.


hth,
 
-----Original Message-----
A couple of possibilities come to mind, Sharon ...

1. The AllowEdits property of your form may have inadvertently been set to
False.

2. The Record Source of your form may be a query that is not updateable;
i.e., it has Groups or Totals in it, among other things. To test this, open
the query itself and see if you can edit data in it.


hth,

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX





.
Unfortunately, it is no. 2, but I can't understand why
Click to expand...
my queries are not editable. I have tried to delete any
fields that might be calculable and I still was unable to
edit them. Can you give me a starting place?
 
How about posting the SQL code for your query so we can see if there is a
work-around.
 
-----Original Message-----
A couple of possibilities come to mind, Sharon ...

1. The AllowEdits property of your form may have inadvertently been set to
False.

2. The Record Source of your form may be a query that is not updateable;
i.e., it has Groups or Totals in it, among other things. To test this, open
the query itself and see if you can edit data in it.


hth,

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX





.
Click to expand...
I am not sure if this is acceptable or not, but I noticed
that you sign your name and then have Law/Sys Associates,
Houston, TX

I work for a lawfirm in Houston also.
 
My company provides custom programming services to law firms and businesses
which service them. If you would like to contact me privately, just
right-click on any of my posts and remove NOSPAM from my email address.

However, I encourage you to post any problems or questions you may have
about Access in these newsgroups. Help here is always free and may assist
others!
 
Back
Top