Export records displayed in form

[Danny]

Good afternoon.

I've got a form with a subform, and the subform's
recordsource is a query. One criteria in the query filters
for null values in a particular field. Once the query
results are displayed, the user will then proceed to fill
in that field with values.

THEN, there is a button on the form to allow the user to
export the records in the subform to an Excel spreadsheet.
The problem is that the OutputTo function re-runs the query
in question, which now will return zero records, since the
user has just filled in the null values.

SO, I want to be able to export the records AS THEY APPEAR
IN THE SUBFORM at the time the user clicks on the button to
export.

Any ideas?

Thanks so much for your help.

Danny