use query as field controlsource

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access query help, expression fields work seperately but not toget 3
Filter records on date & time atrributes of in table stored filena 4
dynamic calculated field in query 3
avoid #error 2
Use In() Expression as Query criteria with guts from Function 1
max for each person 1
How to pass date parameter to query via VBA ? 2
Dlookup in query - any pointers? 1

Back
Top