Button on a map query result.

[Benny Wong]

Hello All,
I am using Access 2000. I have a form that contains a map.
I have embeded a series of buttons on the map and set the button's property to transparent. Each button corresponds to a query. I also have a subform on the form. What I would like to do is when I click on any of the buttons on the map I would like the query result displayed inside the subform instead of displaying the result in another screen as it is now. Thanks in advance for any suggestions or assistance.

 

[Rich]

Assign the subform record source to the query.

 

[Benny Wong]

Hello Rich,
Thanks for responding. I don't seem to understand what you mean by "assign the subform record source to the query". Could you expand on that. If I understand what you meant the subform is Child9 and the source object is where I put the query? I tried that and the subform will display the query result. However, I have several buttons and each is linked to a query. I would like the button when clicked to show the result in the subform. Any help or suggestion is greatly appreciated. Thanks for your time and consideration in this matter.