Editing data in filtered form

[Guest]

I have creaetd an Autoform from a query. There is already existing data in
the tables used in the query. The form works fine when it is first created. I
am able to change data, enter new records & choose items from drop-down
lists. As soon as I use the Find to locate a particular record or sort the
form in any way, it will no longer allow me to edit data. I am not able to
select anything from a drop-drown. The list opens, but beeps if I attempt to
click on anything. I have a database of 7000 records. How can I locate a
particular record & still be able to edit the data in that record???? It's
like I must have just missed one small thing here.
Thanks!!!

 

[Allen Browne]

Kelly, I have not experienced this, so I hope others will also reply if they
have.

You are saying that your form becomes read-only just because you use the
Find dialog (from the Edit menu)? Could you provide more info please:

1. What version of Access is this?
(I'm guessing 2002 or 2003.)

2. What is the RecordSource of your form?
(I'm guessing it is a SQL statement/query that contains multiple tables.)

3. What control is the cursor in when you perform the find?
(I'm guessing a combo with the bound column zero-width.)

4. Does it only become read-only if you use the Find dialog, i.e. you can
still edit if you change records with the navigation buttons?

5. Does it only become read-only if you find/sort on the combo, i.e. you can
still edit if you find on text box?