Subforms new records

[Harley Feldman]

I have an Access form with two lower levels of subform linked. The forms work great when there is data in the tables. However, I would like to add a new record on the form, and its associated subforms and be able to enter data. This also works fine except when there is no data in the linked table. I have the subforms in a datasheet layout from which I can add new data to the underlying table. However, if I create a new record at the form level, then I get blank screens where the subforms should be, and I cannot enter data. How can I display the subforms as datasheets when there is no current data in the associated subform to be able to enter new records?

Harley

 

[Allen Browne]

Harley, the Detail section of a form goes completely blank if:
a) there are no records to display, and
b) new records cannot be added.

We know why (a) is true: it's a new main record, so there are no related
records yet.

You need to discover why (b) is true. Examples:
1. The subform's AllowAdditions property is No.
2. The subform is bound to a read-only query.
3. Permissions.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have an Access form with two lower levels of subform linked. The forms
work great when there is data in the tables. However, I would like to add a
new record on the form, and its associated subforms and be able to enter
data. This also works fine except when there is no data in the linked
table. I have the subforms in a datasheet layout from which I can add new
data to the underlying table. However, if I create a new record at the form
level, then I get blank screens where the subforms should be, and I cannot
enter data. How can I display the subforms as datasheets when there is no
current data in the associated subform to be able to enter new records?

Harley

 

[Harley Feldman]

Allen,

That was the problem. On the first level subform, I had missed a
"AllowAdditions" property setting.

Thanks,

Harley