Child Master Link w/ unbound obj

[Avaughan]

I am trying to add additional link criteria for a form and subform. The employee Id is the link fields but I also need to throw in a "year" unbound combo box on the master form and filter the child (subform) info also with that. Can use code if necessary.

Any ideas?

 

[Pat Hartman]

You can't use an unbound field as part of the master/child link. Change the subform's query to refer to the "year" field on the main form in its Where clause. You'll need to requery the subform in the "year" field's AfterUpdate event.