[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 496
  • 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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