I have a subform that links the ids in two tables. It used to work fine -- but now when the master form opens the one thing that comes up on the subform is a 'new' records (blank). Or the Master file shows as a new record with all subform records. There must be a setting that I am missing.
Master: ID = Project ID in tbl_Project
Subforms: fkproject = Project ID in tbl_ResourceRequest
Attached are sample tables and forms.
Thanks for your help,