Originally Posted by
John_G
I don't think there is a workaround to make them visible. A form/subform that doesn't allow additions will look like that if there are no records to display, which in your case doesn't happen until the record is saved in the main form.
What you could do is keep all the subforms hidden (.visible = False) until the record is saved, then you could unhide them (.visible = True) in the same code block where you do the requery. I haven't tried this, but I think you can apply the .visible = True/false to the tabs instead of the subform containers, and by doing that your users won't be able to click a tab and see "nothing". In other words, keep then out of the subform tabs until the record is saved.