Re: Edit filtered record

From: Dirk Goldgar (dg_at_NOdataSPAMgnostics.com)
Date: 08/14/04 

Date: Sat, 14 Aug 2004 12:02:42 -0400

"FreeMaster" <FreeMaster@discussions.microsoft.com> wrote in message
news:C4044E3E-D2C7-45F7-8065-5959C72A6F34@microsoft.com...
> Hi,
> I have created a tabular form that lists brief description about every
entry
> in one of my tables. when clicking on any of these lines, a new form will
> open displaying all information stored for that record.
>
> This is working fine when I want to display records. But I can not edit
the
> records if they are filtered.
>
> Any idea how to solve this?
>
> Thank you

You mean that the form you open to display the detailed information doesn't
allow you to edit the record? This could be for several reasons. Are you
by any chance opening the form read-only? (Check the code that opens the
form when you click a line on the summary form.) Is the form's AllowEdits
property set to No? (Check the Data tab of the form's property *** in
Design View.) Is the form based on a query that is not updatable? (If the
form is based on a query, try opening that query all by itself as a
data***. Can you edit its records or add a new one?) 

-- 
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup, not by e-mail)