Subform problem

  • Thread starter Thread starter Janet
  • Start date Start date
J

Janet

I'm having problems with a subform. I've used these many
times before and can't figure out what I'm doing wrong
this time.

The problem is, the subform does not allow me to add new
records. I've set the child/master link between the
subform and the mian form and I've created a one to many
relationship between the main table and the table
containing the information in the subform.

What else could I be overlooking?
 
The problem is, the subform does not allow me to add new
records.
Click to expand...

Typically this happens when the Query upon which the subform is based
is not updateable. Try opening the query in datasheet mode; can you
add records there? Post the SQL of the query here if it's not obvious
why it's not updateable (e.g. no Totals query is ever updateable).
 
Back
Top