How to display values from a function in a report

[pleasehelpalot]

I have a function that returns ten names. How do I pass the names to a report. I want the user to click a command button and get the names either in a report or on screen.
The only reports I've created were based either on a query or table.
Thanks for any help

 

[dhookom]

A function basically returns a single value/expression. You can use your functions almost anywhere that built in function can be used.

Create a text box and set its control source to your function like:
=MyFunctionName()

Reports don't need to be bound to a table or query.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]