Can't Type In A Subform?

  • Thread starter Thread starter David P. Donahue
  • Start date Start date
D

David P. Donahue

I have a form for editing data in a table. I embedded a
subform for editing the record from another table that is
linked with a column in the main table. However, it won't
let me type in the subform. Each form works fine
individually, but when placed as a subform (using the
wizard for adding a subform from an existing form) no data
entry is allowed. Any ideas?


Regards,
David P. Donahue
 
Hi Dave,
Can you make an updatable query from these two
tables using the same relationship that you have in your
form? If you can't add a new record to the query then the
problem is not with the form but with the relationship
between the two tables. If the query is updatable, then
check the properties on the form and subform to make sure
that editing and adding records have not somehow gotten
set to false.

The Easy Day
 
Not sure... The main form table has a column that links
(many to one) to the sub form table's primary key. That
shouldn't prevent any updating, should it? As for the
properties, I've been combinb through them and toggling
some to see if they're the problem (then, of course,
toggling them back when that didn't fix it).


Regards,
David P. Donahue
 
Dave,
From what I understand from your reply, the Main table
is the MANY and the subform table is the ONE. This is the
reverse of what it should be, i.e. an order can have many
details. So an orders table would have one to many
relationship to an "Orders Detail" table.
Try building a new query with the fields from both
tables and the current relationship. Can you update it? If
not, change the relationship and try again.

The Easy Day
 
Back
Top