Subform won't automatically fill.

[IncidentalProgrammer]

Hi, all!

I have a form that's supposed to be analyzing account/policy data. On it, there is a subform that shows some specific data about the insurance policy, itself. I have a field in the subform, and one in the main form for the policy number, and they are linked as master/child. However, under no circumstances can I get the subform to fill based on the main form; it simply picks one record, and runs with it.



I have tried VBA to pass the value from the master to the child or to requery whenever the master field updates, and nothing works. Can anyone think of what could be stopping it from updating? I have another form where this same sort of setup is working perfectly.

[June7]

The policy number is primary key in main table?

If you want to provide db for analysis ...

[IncidentalProgrammer]

You always know how to fix it! It was not the primary key.

Thanks once again, June7!