What can prevent you editing a form?

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

Guest

I have a form based on a table. Even though the macro to open it sets the form as editable, and the actual form ha

Allow edits: Ye
Data entry: N
Record Locks: No Lock

I cannot edit it. Any ideas
Much Thanks in advanc
Alicia
 
Hi Alicia,
Items to check: a. Can you enter data into the
table directly? Usually this is YES, but it's worth
checking.
b. If you are using a query behind
the form, check to make sure the query is updatable. Can
you enter and save a new record in the query?
c. Take the macro out and open the
form without it. Does this solve the problem? If so, the
macro is holding things up.

Hope This Helps
-----Original Message-----
I have a form based on a table. Even though the macro to
Click to expand...
open it sets the form as editable, and the actual form has
 
Hi Art

Could you alter your newsreader settings to include the standard "RE:" on
your replies? It's a bit annoying to open what seems to be an original post,
only to see that it is actually a reply - not an original.

Cheers :-)
TC
 
I have tried these items; it is none of them.
I have some more information however:
Data entry Yes
Aloow Edits Yes
Allow Deletions Yes
Allow Additions Yes
Recordset Type Dynaset
Record Locks No Locks
The Macro performs a filter on the table.
Also, it is a linked table.
Any other ideas?
Thank You


----- Art wrote: -----

Hi Alicia,
Items to check: a. Can you enter data into the
table directly? Usually this is YES, but it's worth
checking.
b. If you are using a query behind
the form, check to make sure the query is updatable. Can
you enter and save a new record in the query?
c. Take the macro out and open the
form without it. Does this solve the problem? If so, the
macro is holding things up.

Hope This Helps
-----Original Message-----
I have a form based on a table. Even though the macro to
Click to expand...
open it sets the form as editable, and the actual form has
 
Back
Top