RE: Cannot edit form

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Art (anonymous_at_discussions.microsoft.com)
Date: 03/23/04 

Date: Tue, 23 Mar 2004 08:38:35 -0800

Can you add or edit data directly into the table itself?
If so, then it is not the table but the form which is
causing the problem.

Hope This Helps
>-----Original Message-----
>Again this does not work. Is it something to do with my
Recordset defined as Dynaset?
>Alicia
>
> ----- Art wrote: -----
>
> Hi Alicia,
> Turn the filter off and try to edit again.
It
> may be a conflict between the filter code and the
edit
> which is trying to make changes or add a record in
spite
> of the filter.
>
> Hope This Helps
> >-----Original Message-----
> > I cannot edit one of my forms. I do not know why.
> >I have some more information however:
> >Data entry Yes
> >Allow 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, Alicia
> >>.
> >
>.
>

Relevant Pages

  • Re: Form View using snapshot?
    ... Allen Browne - Microsoft MVP. ... controls instead of trying to modify the type of recordset the form uses. ... The add and edit work fine. ...
    (microsoft.public.access.formscoding)
  • Re: Edit Method in VB
    ... > I used to edit records in a module by using a tbl.Edit method. ... > under Tools, References, but it still doesn't work. ... but it won't work in my database. ... > method that can be used to edit a record in a recordset? ...
    (microsoft.public.access.modulesdaovba)
  • Re: Updating a recordset
    ... > recordset Addnew method, I can delete data but I can not ... > update the data using the Edit method. ... don't have the dot in front of your call to the Edit method. ... If the table is empty, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Pass Filter by form to recordsetclon
    ... edit button, it is not applied to the new ... recordset. ... pass the filter that I applied before pressing ... The filter is in the .Filter property of the Form. ...
    (comp.databases.ms-access)
  • Re: Form View using snapshot?
    ... Just run the locking code in the Load event of the form. ... controls instead of trying to modify the type of recordset the form uses. ... > The add and edit work fine. ...
    (microsoft.public.access.formscoding)