use query as field controlsource

hi,

I have the following query:

SELECT find_weekdays(date()-1,Date())-2 AS workdays;

of course the find_weekday() is a function/module. I just need to know how
to base the controlsource of a form field on the query's returned value.

thanks in advance,
geebee

Open the form in design view and click on the menu VIEW - Properties. Enter
the query name as Record Source.

"geebee" wrote:

hi,

I have the following query:

SELECT find_weekdays(date()-1,Date())-2 AS workdays;

of course the find_weekday() is a function/module. I just need to know how
to base the controlsource of a form field on the query's returned value.

thanks in advance,
geebee