Click a button and search a query based on item in datasheet

[lostinaccess]

I'm building an access database for a mortgage portfolio. Our properties can have prior mortgage charges against specific properties.

I've created an "add charge" & "view charge" button in one of my subforms. "Add charge" obviously opens up a new dialogue box and allows you to input a mortgage against a property and register it.

I want the "view charge" button to open a query (that is already built) to search for the property in the datasheet.

for example: 123 Fake st has 6 separate charges against it, when I click "view charges" a dialogue box should appear showing all charges against it.

[zmbd]

Normally I would suggest a subform arrangement

For example, the following image show the Parent form, a child form and a grandchild form. I've linked the two subforms togeither using an unbound textbox control that derives it's value from the child subform. Normally the textbox control is hidden; however, for this example I've left it visible.

I've also included the FK_Fields in each subform so that you can see how the records are related between the forms and underlying tables *(opps, didn't show the parent key in the child subform; however, I think you get the idea between the child and the grandchild subforms.)

At work I have an Unbound form with three subforms. The subforms are linked using that same textbox control idea linking the three forms together.

The advantage here is that you don't need code to enter the related records (ie I can enter a grandchild and Access will take care of the related fields - OF COURSE, I have the related fields as part of the form's recordset even if they are not shown on the form) nor to have the two subforms sync due to the link-master-field for the grandchild subform referring to the unbound textbox.
If you really want the pop-up we can work thru that...