Subform not allowing new records

[lscheer]

I know this should be a simple "duh" solution, but some of my Access skills are getting rusty, and after an hour of searching various terms, still haven't come up with an answer.

I added a subform to a main form with the correct parent-child linkage setup. Mainform Parent field is PK, subform child field is FK. Subform is based on a table with a many-to-one relationship with the parent table. So far only the fields with data in them show up on the subform. For a parent record that does not have a child record associated, the subform is completely blank and there is no way to add a new record to the subform at all.

What am I forgetting/overlooking?

Thanks in advance!

 

[boblarson]

Is the underlying subform query updateable? Try opening that query by itself and see if you can add a record. (and make sure the Allow Additions is set to YES)

 

[missinglinq]

Also, can the main form be updated? The subform is a control on the main form; if the main form cannot be updated, the subform can't be. A form or subform showing nothing, not even blank controls, indicates an empty recordsource and an inability to be updated.

 

[lscheer]

Yes, the recordset is updateable in the query and also when I open the subform on it's own. Allow additions is set to yes, and YES, the main form is also updateable. Originally the RS was simply the table on the many side of the relationship, but I changed it to a query with both the parent and child tables and it still doesn't work right on the subform when nested in the mainform.

I have tried re-adding the subform and re-setting the link fields. I tried creating an outer join in the query that shows all parent table fields and only child table fields where matching. This actually displayed a blank record in all parent fields on the form, but they weren't updateable.

Still no luck...