Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Displaying query results on a separate tab

Status
Not open for further replies.

pigsie

Programmer
Joined
Dec 19, 2000
Messages
307
Location
GB
Hi

Hopefully someone will be able to point me in the right direction. I have a form with a tabbed control, on one tab I have a number of fields which allow the end user to enter some criteria, there is also a button which when clicked runs a query with the criteria the user entered. The problem I have is as follows - 1. the results of the query are launched in a new datagrid which pops up, what I actually need is for the data to populate a datagrid control on another tab. I would be grateful for any insight.

Thanks
 
make a form with the query as it's Recordsource. Embed that form into the tab control. Now it's a SUBFORM. In the button's OnClick event, requery the subform.

something like

me.SubFormName.requery

Hope that helps.
g

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top