Opening a query in a subform

  • Thread starter Thread starter Nick Anderson
  • Start date Start date
N

Nick Anderson

I have a query that is built to look at the name of the employee and provide
me with data for that agent. I have the form built now so when I hit the
button it populates the query. What I am trying to do is when I click the
button, have the data populate in a subform/subreport. I have tried various
ways but none seem to work. Does anyone have any suggestions?
 
On Fri, 4 Sep 2009 06:27:07 -0700, Nick Anderson

That query would become the RecordSource of your subform. You'd
probably want to put the DefaultView in Datasheet mode.

-Tom.
Microsoft Access MVP
 
Tom,

Thanks for the response. I got the subform to populate the query, however,
when I click the button the results still show in a new window. What I want
it to do is when I click the button to have the results appear in the
subreport.

Do you have any suggestions for that.

Thanks
Nick
 
Back
Top