Subform problem

[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?

 

[John Vinson]

The problem is, the subform does not allow me to add new
records.

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).

 

[Janet]

That was it! Thanks. I'll add that to my "tips" file for
future reference.