• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 500
  • Last Modified:

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?
0
SteveL13
Asked:
SteveL13
  • 4
  • 3
1 Solution
 
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
 
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
pdebaetsCommented:
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
 
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now