Adding a new record to a sub form based on input from the main form

[gal4y]

I have a form that has the main form from a conference table that holds conference data (location, dates, name, etc.) and a sub form that show the people that will go to the conference (conference_coverage table). There is one to many relationship.

If you add a new conference on the form the sub form automatically seems to add the name of the conference and a blank for the faculty but it is not adding a new record.
I don't see the asterik in the subform so when I go to the conference_coverage table the record is not there.

You can see the record if you add a person and then delete the person.

I need some way to automatically add a blank record in the conference coverage table and still be linked to the main table (form).
I tried to use the default character block but it didn't work.

Thank you in advance for any help
Greg

 

[VicM]

Greg:

Not sure why you need to have a blank record in the coverage table.

A record will be generated (assuming you have the parent/child relationships correct) when you begin entering data into the subform.

Do you have a primary field defined in the coverage table? If so and it's an autonumber, no record will be generated until you enter data in one of the other fields of the subform.

Could you give a bit more detail of the relationships between the main form and the subform? What field(s) are linked? What fields in the underlying tables are key fields?

Hope this helps,

Vic