Can't edit data in a subform

O

ortega.rad

I have a form which allows you to select a record. That record has
other records asscociated with it via a table. The asscociated records
of the record selected on the main form are shown in a subform.

This all works fine. But then, when I try to edit a record in the
subform It does not let me. I have a dropdown box, but cannot select
from it... does anyone know why this is, and what I could do to fix it?
 
J

Jeff L

It could be several different things, but here are some common ones.

1. Open your subform in design view and look at the properties of the
form. Look at the data tab. If Allow Edits is set to No, then you
can't edit data without changing it to Yes.

2. Look at the properties of your field you are trying to update.
Again look at the data tab. If Locked is set to Yes, or Enabled set to
No, then you cannot edit the field. Enabled must be Yes, and Locked
No.

3. If your Record Source for the form is a query that has outer joins
you cannot edit the data. If you don't know what an outer join is,
look at the query and if there is an arrow going from one table to
another, that is an outer join.

4. If your Record Source for the form is a query that has joins, but
the join is not on the primary key of one of the tables, you probably
will not be able to edit the data.

That should give you some things to check for.

Hope that helps!
 
Top