Subform not showing any records when on another form

[jazzman831]

I have a subform with a few dummy records in it for testing, which is nested onto a main form. When I open the subform, the records all show up, but when I look on the main form, it's acting like there aren't any records. If I enter a record using a known primary key already in the table it gives me an error message, but I can't make the data show up on the main form.

I have several other subforms, all created and added the exact same way, and those are all working fine. I thought maybe I messed something up, so I tried deleting and reading the subform, but that didn't fix the problem.

I haven't done any queries, I haven't put in any code yet, I'm still putting together the bare-bones database. I've looked everywhere and can't find anything helpful. I've attached a screenshot and a zipped version of my db.



THANKS!



Coin Collection.zip

[RuralGuy]

Have you set the LinkChild/MasterFields of the SubFormControl correctly yet?

[jazzman831]

Ooooh, I see. I understand what it's doing now and I've gotten it to do what I want. I didn't know about the link child/master properties.

Thanks!

[RuralGuy]

Glad we could help. I marked this thread as Solved for you.