Subform not display record

I have a form that has a subform on it.  When I open the form to add a record the subform has no rows in it to add records to the subform's underlying table.  I suspect that this may be because the main form has not been added to the table.

How can I make the subform display a row to add a record to it?
SteveL13Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
pdebaetsConnect With a Mentor Commented:
Are the subform control's Link Master Fields and Link Child Fields properties set? What are they set to?

What is the record source of the parent form?

What is the record source of the subform?
0
 
pdebaetsCommented:
Is your parent form a bound form? Try typing some data into the parent form before attempting to enter data into the subform.

Also check that the subform's AllowAdditions property is set to Yes.
0
 
SteveL13Author Commented:
Yes the parent form is a bound form.  I did type into one of the parent's fields and the record number appears on a field I have in the parent form right after I type the first character in a field.   The subform's AllowAdditions property is set to Yes.

But no rows show up in the child form so I can make a data entry in the child form.
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
SteveL13Author Commented:
To prove my theory that the subform is not displaying the ability to add a record I typed something into a parent form field, saved the record by closing the form.  Then opened the form to edit the record and the subform DOES have a blank row so I can add a record or more to it.

???
0
 
SteveL13Author Commented:
The properties are both set to ... MatlsTransHeaderID
The record source of the parent form is ... tblMatlsTransHeader
The record source of the subform is ... tblMatlsTransDetail
0
 
pdebaetsCommented:
All looks good to me. Don't know why you're having a problem. Can you post a db with the form/subform with sample data?
0
 
SteveL13Author Commented:
I had a spelling error in the properties of the child form. Thanks for the help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.