Create a query based on the data you want to export. In the criteria of the ID field put..
changing "frmYourForm" to the name of the form in question and "ID" to the control on the form that holds the ID.
In the OnClick event of your button put the following code (if you are importing to Excel)
Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!
Or try our Ask An Expert service to answer any of your questions!