Link to home
Create AccountLog in
Avatar of SteveL13
SteveL13Flag for United States of America

asked on

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?
Avatar of pdebaets
pdebaets
Flag of United States of America image

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.
Avatar of SteveL13

ASKER

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.
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.

???
ASKER CERTIFIED SOLUTION
Avatar of pdebaets
pdebaets
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
The properties are both set to ... MatlsTransHeaderID
The record source of the parent form is ... tblMatlsTransHeader
The record source of the subform is ... tblMatlsTransDetail
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?
I had a spelling error in the properties of the child form. Thanks for the help.