By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,949 Members | 904 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,949 IT Pros & Developers. It's quick & easy.

Can't edit data in a subform

P: n/a
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?

Aug 16 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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!



or********@gmail.com wrote:
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?
Aug 16 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.