Subform not populating from ComboBox

[DMJ]

Attachment 11673
The subform is stuck on one line from a table, it should be populating from the ComboBox above.

[June7]

Which subform has the issue and which is the main form?

[DMJ]

Which subform has the issue and which is the main form?

The main form is frm_PersonAddressPhoneEDIT the subform is frm_AddressSubform. Combobox is from the qry_Person Query Lookup

[June7]

There is no code to filter or go to address record.

Options to filter the records:

1. parameterized query, review http://datapigtechnologies.com/flash...tomfilter.html

2. VBA code to set the Filter and FilterOn properties of form

As shown in the tutorial, a form/subform is not necessary. All can be done on one form. No reason to make it more complicated.