Can't add data via a subform

[wardw]

I'm new to subforms, so this may be a very easy problem to solve. I'm building a database to record newspaper obituary details, such as name, age of the deceased, and the obituary publication information. Some of the deceased persons have obituaries in more than one newspaper, so in that case I have a button on the main form: "Enter Multiple Obituaries".



Clicking it opens the subform containing the same fields as the main form for this data-- Publication Name (a list box), Publication Date, Page, and Col. No.--except there are three sets of these fields; one for each obituary (a max of three can be input).

The list boxes appear correct in the subform, and the Publication Date field accepts dates, but the Page and Col. No. fields get an error message: "Control can't be edited: It's bound to unknown field 'PubPage' [or 'PubCol']. I've used Properties to ensure the Control Source is PubPage [or PubCol] on the main form. (Of course, no PubPage or PubCol is filled in on the main form at this point.)

How can I make the subform enter data into my PubPage and PubCol tables?

[rzw0wr]

Can you show us your tables.
Sounds like they are not normalized yet.

You should be able to add more data without a subform.

Dale