>How can I use function as a recordsource in grid (for example recordsource sholuld be function(table.field) ?
The grid.recordsource needs to be a set of rows - a table, cursor, result of a SQL statement etc.
Within the grid, you have columns. Within the columns you can have controls, textboxes by default.
You can't use an expression for the .controlsource of the text box, but you can for the column. Leave the controlsource of the text box blank.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up